Postgres Internals: How Postgres Stores and Retrieves Your Data
A visual deep dive into Postgres internals: how data is stored in pages, what happens during an INSERT, and how the query planner decides to fetch your data.
PostgreSQL internals, performance optimization, and backend engineering
A visual deep dive into Postgres internals: how data is stored in pages, what happens during an INSERT, and how the query planner decides to fetch your data.