What If We Opened PostgreSQL's Hood?
summary
A deep dive into PostgreSQL internals showing how data is stored and retrieved, walking from a simple SQL query through the planner, storage engine and recovery systems. Covers concrete database technologies and concepts used by Postgres: the query planner, write-ahead log (WAL), MVCC, tuple layout, VACUUM, crash tolerance and high-availability mechanisms.
AI-written summary · about
chapters (7)
- 0:00PostgreSQL intro
- 2:31Cluster structure & files
- 13:55Memory & processes
- 20:57MVCC concurrency
- 37:15VACUUM importance
- 42:17WAL & crash recovery
- 45:08Summary
related talks
49mHow Databases Work - For Developers, Accidental DBA's and Managers
39mDeep dive into PostgreSQL internal statistics
21mA Guided Tour Through Postgres Internals with Elizabeth Garrett Christensen
51mHow does PostgreSQL actually work
50mPostgres from the dawn of time to the present day
46mHow PostgreSQL Can Hurt You When You Least Expect It
01h 00mPostgres at the Heart of Your Data Center
47mBeginner's guide to PostgreSQL Hacking