The Internals of PostgreSQL

 (interdb.jp)

74 points | by ibobev 2 hours ago

1 comments

  • gopalv 2 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.

    [-]