The space isn't immediately cleaned up because of Postgres's version-based MVCC.... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

immibis 7 months ago | parent | context | favorite | on: DELETEs Are Difficult

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 7 months ago [–]

Yes, but that's in PostgreSQL, not in MSSQL or the other systems I described (and which the gps seemed to refer to)

Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact