News for hackers. Stuff that matters.

A comment on The Internals of PostgreSQL.

Re:The Internals of PostgreSQL by gopalv on Tuesday November 03, 2026 @05:40PM (#50359266)
The latest Jepsen report on particledb triggered a new found interest in the SSI implementation in postgres.

If you are just skimming this doc, The HoT update path is the section I would jump to.

Understand HoT and then read the zHeap implementation notes (also of TOAST) puts a good mental model of what postgres does and what it doesn't do.

[ Parent | on HN ]
Re:The Internals of PostgreSQL by refset on Tuesday November 03, 2026 @06:49PM (#50359845)
Incidentally, the 2020 Jepsen report on Postgres found a bug in the SSI implementation [0]

[0] https://news.ycombinator.com/item?id=41560556

[ Parent | on HN ]
Re:The Internals of PostgreSQL by hmartin on Tuesday November 03, 2026 @08:59PM (#50360706)
The had a safe super intelligence bug dating back to 2011?

Wow so ahead of their time.

(And since I'm bad at sarcasm and don't wish to mislead, SSI = Serializable Snapshot Isolation in this context.)

[ Parent | on HN ]