3 ms·
> The space will be reclaimed over time as existing rows are updated. Or as you VACUUM, correct? I think it lets you specific a column name too
by airstrike 6y ago
> The space will be reclaimed over time as existing rows are updated.
Or as you VACUUM, correct? I think it lets you specific a column name too
- masklinn 6y agoVACUUM 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