The Internals of PostgreSQL

 (interdb.jp)

53 points | by ibobev 1 hour ago

1 comments

  • gopalv 1 hour 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.

    [-]