From the HackerLinks archive

The Internals of PostgreSQL

Free PostgreSQL internals guide; a commenter recommends starting with heap-only tuple updates.

At a glance:
First seen:2026-11-05
Last seen:2026-11-05
Times seen:1
Website:interdb.jp

The short version

Free PostgreSQL internals guide; a commenter recommends starting with heap-only tuple updates.

Why it caught our attention

A specific reading recommendation supplies a useful entry point into a substantial technical guide.

Where it surfaced on Hacker News

2026-11-05

“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.”

gopalv · recommendation

Direct HN comment

The Internals of PostgreSQL