Database Design & Internals
Indexes, query planning, transactions and how databases are built.
Expert
Research-level depth and specialist material.
Course
Expert
↗ External site
CMU 15-721: Advanced Database Systems
Lecture notes, slides and recordings on modern database design: in-memory engines, query optimisation, vectorised execution and storage formats.
Sign up to see the source
Document
Expert
↗ External site
The Internals of PostgreSQL
A detailed book-length guide to how PostgreSQL works inside: process and memory layout, query processing, transactions, the buffer manager and replication.
Sign up to see the source