A journey through PostgreSQL internals: the planner, executor, buffer pool, WAL, and MVCC — understanding these makes every query you write more intentional.
