PostgreSQL 14 Internals: A 548-page deep dive into how the database really works
PostgreSQL Internals [pdf]
Egor Rogov's PostgreSQL 14 Internals, translated from Russian by Liudmila Mantrova and published by Postgres Professional, is a 548-page book that dissects the database's inner workings. It covers isolation and MVCC, buffer cache and WAL, locking, query execution, and index types from hash to BRIN. The PDF is freely available, offering a rigorous yet accessible guide for developers who want to understand PostgreSQL beyond the SQL surface.
The elephant on the cover is a fragment of an illustration from Edward Topsell's The History of Four-footed Beasts and Serpents, published in London in 1607.
- SurajMishra
It looks good but it's from 2023 (postgres 14). Does anyone have anything from after 2025?
- Plaoo
Awesome.