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.
alt Hacker News
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.