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.
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.