2 ms·
The space isn't immediately cleaned up because of Postgres's version-based MVCC. It should only need to record that it marked the row as deleted, and the vacuum
by immibis 2y ago
The space isn't immediately cleaned up because of Postgres's version-based MVCC. It should only need to record that it marked the row as deleted, and the vacuum shouldn't need to record anything because it isn't atomic.
- mattashii 2y agoYes, but that's in PostgreSQL, not in MSSQL or the other systems I described (and which the gps seemed to refer to)