3 ms·
VACUUM just marks tuples as free spaces so they can be reused. This is part of > The space will be reclaimed over time as existing rows are updated. because o
by masklinn 6y ago
VACUUM just marks tuples as free spaces so they can be reused. This is part of
> The space will be reclaimed over time as existing rows are updated.
because of MVCC, updating a row really inserts a new row and the old one eventually becomes free space (once a vacuum comes around to marking it).
VACCUM FULL, however, will rewrite the entire table.
- airstrike 6y agoGood to know, thank you very much