126 pointsby ibobev4 hours ago1 comment
  • gopalv4 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.

    • refset3 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

      • hmartin21 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.)