NHacker Next
  • new
  • past
  • show
  • ask
  • show
  • jobs
  • submit
▲The Internals of PostgreSQL (interdb.jp)
gopalv 4 hours ago [-]
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.

refset 3 hours ago [-]
Incidentally, the 2020 Jepsen report on Postgres found a long-standing bug in the SSI implementation [0]

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

hmartin 43 minutes ago [-]
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.)

getbrew 9 minutes ago [-]
[flagged]
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact
Rendered at 02:42:29 GMT+0000 (Coordinated Universal Time) with Vercel.