The short version
Free PostgreSQL internals guide; a commenter recommends starting with heap-only tuple updates.
From the HackerLinks archive
Free PostgreSQL internals guide; a commenter recommends starting with heap-only tuple updates.
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
“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