Postgres uses MVCC, which is basically copy-on-write: every UPDATE to a row actu... | Hacker News

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

		cesarb on Aug 1, 2016 \| parent \| context \| favorite \| on: Why we lost Uber as a user 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 on Aug 1, 2016 [–]

Ah, thanks for the clarification - the bloat issue makes more sense now.

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