The Internals of PostgreSQL(interdb.jp)
369 points by ibobev 8 days ago | 32 comments
tl;dr: "The Internals of PostgreSQL" by Hironobu Suzuki is a free online documentation (first published 2015) explaining how PostgreSQL's subsystems work internally, covering 12 chapters including query processing, concurrency control, VACUUM, buffer management, WAL, PITR, and streaming/logical replication. It targets PostgreSQL versions up to 19-beta and has been cited in academic papers, with a Chinese translation published in 2019. Recent additions include asynchronous I/O (June 2026) and a beta chapter on logical replication (May 2026).
HN Discussion:
  • ↑Points to specific chapters (HOT, zHeap, TOAST, SSI) as highest-value reading in the doc
  • ↑Shares practical HOT update tuning advice derived from the book's content
  • ~Notes the book is outdated on recent Postgres 18 FTS/collation changes
  • ~Notes the book doesn't cover newer MVCC implementations like OrioleDB
  • ↑Personal testimonial of the book's value for learning database kernel development