The Internals of PostgreSQL
Points and comments are a snapshot, not live.
A detailed guide to PostgreSQL internals, updated through version 19-beta.
Hironobu Suzuki's free documentation explains PostgreSQL subsystems, covering process and memory architecture, query processing, concurrency control, WAL, and logical replication. It targets versions 19-beta and earlier. The site was updated in 2026 with a new section on asynchronous I/O and a beta chapter on logical replication. Some academic papers cite it, and a Chinese translation was published in 2019.
What commenters are saying
Commenters praised the HOT update section as the most practically useful chapter, noting that HOT is disabled when an indexed column changes. A discussion of alternative MVCC implementations like OrioleDB emerged, with some arguing vacuum-based MVCC causes operational issues. One comment noted that Postgres 18 changes FTS behavior to depend on the cluster's collation provider.