How PostgreSQL Really Works: Postmaster, Buffer Pool, and WAL
PostgreSQL’s internals come into focus when you follow the journey: TCP connects to a postmaster, each session gets a backend, pages live in a shared buffer pool, changes are protected by WAL, and checkpointers flush dirty pages while standbys replay WAL for recovery.