Tutorial Presented by Bruce Momjian of EnterpriseDB at PGConf Silicon Valley 2015

PostgreSQL Internals Through Pictures This talk is designed for advanced PostgreSQL users who want to know more about how the database internally processes a query. It is also ideal for people wanting to modify the PostgreSQL server source code. It covers PostgreSQL network communication, query parsing, optimizer plan selection, multiversion concurrency control (MVCC), and internal storage characteristics. It does not require any programming knowledge.