recall

← recall

vacuum term

Postgres reclaiming space from dead tuples

Postgres uses MVCC — updates create new row versions, old ones become 'dead.' Vacuum reclaims space and updates statistics. Bloat happens when vacuum can't keep up. Long-running transactions block vacuum from cleaning newer dead rows.

aliases: autovacuum

topics: databases, postgres

references: