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 on Dec 2, 2024 \| 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 on Dec 2, 2024 [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact