3 ms·
Postgres uses MVCC, which is basically copy-on-write: every UPDATE to a row actually creates a new row. Once all transactions that could see the old row have fi
by cesarb 10y ago
Postgres uses MVCC, which is basically copy-on-write: every UPDATE to a row actually creates a new row. Once all transactions that could see the old row have finished, the old row can be pruned.
- cyberferret 10y agoAh, thanks for the clarification - the bloat issue makes more sense now.
- deleted 10y ago[deleted]