GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com

myBlog

myBlog Home

Back to Blog MTNCOMP


SQL

PostgreSQL and optimization and freeing up disk space

by Mountain Computers Inc., Publication Date: Monday, February 1, 2021
View Count: 88, 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.

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