When your storage is nearly full, you have 2 options to free it up:
- Scale up –> burning some money
- Delete data –> lost your records!
I've been using both options, and both have drawbacks.
Lets talk about option 2: Delete data
Deleting a lot of records won't increase your free storage immediately. Deleted records will become dead tuples.
Use VACUUM to reclaims storage occupied by dead tuples. using VERBOSE ANALYZE option gives better understanding about dead records.
Don't forget to REINDEX all of your affected index.
More info about VACUUM and REINDEX
comments powered by Disqus