GoGreen PC Tune-Up™
Learn More

Insta-Install™
this is how ssl encrypt our websites
MTNCOMP | List View | Table View | myBlog (1747 Entries)
myBlog Home

Blog


PostgreSQL and optimization and freeing up disk space

SQL

by Mountain Computers Inc., Publication Date: Monday, February 1, 2021

View Count: 728, Keywords: PostgreSQL, Optimization, Disk Space, Hashtags: #PostgreSQL #Optimization #DiskSpace



this is something you don't see everyday, the optimization techniques posted for a SQL database that actually makes sense; however, the first option of indexes that are not or never used, then something was wrong with the design and architecture to have created the index in the first place.
 
Overall, the article below is a great read for those in the bulk data world, the ETL world, and maintaining databases of 1TB and higher up to petabyte database sizes.
 
The Unexpected Find That Freed 20GB of Unused Index Space
 
REF: https://hakibenita.com/postgresql-unused-index-size
 
more to come...

if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

© 2024 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.