Lessons
How Postgres data lives on disk
intermediate · 22 min
On-disk layout
8KB page
B-tree index
WAL + buffers
MVCC visibility
Reset view
PGDATA, databases, relations — one file per relation, split past 1GB.
Concepts