Database System Internals (PostgreSQL)

Most database courses teach you how to talk to a database. This course teaches you how the database talks to the hardware. Database System Internals (PostgreSQL) is a rigorous, comprehensive analysis into the physical architecture and execution pipeline of the world's most advanced open-source relational database. Moving beyond logical design and SQL syntax, this course strips away the abstraction layers to explore how PostgreSQL parses queries, estimates costs, manipulates memory caching, enforces concurrency without locking, and guarantees data durability.