The Internals of PostgreSQL

 (interdb.jp)

133 points | by ibobev 4 hours ago

2 comments

  • gopalv 3 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 2 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 39 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 5 minutes ago
    [flagged]