PostgreSQL and optimization and freeing up disk space
by Mountain Computers Inc., Publication Date: Monday, February 1, 2021
View Count: 992, 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
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.