Postgres Architecture Explained

Explore the intricate architecture of PostgreSQL in this comprehensive 33-minute video. Dive deep into the process-based structure of Postgres, examining key components such as MVCC, postmaster process, backend processes, shared buffers, and background workers. Learn about auxiliary processes including the background writer, checkpointer, logger, autovacuum launcher and workers, and WAL processes. Understand the differences between processes and threads, and gain insights into how these architectural choices impact scalability and performance. Follow along with a detailed breakdown of each component, from the startup process to the intricacies of the WAL (Write-Ahead Logging) system. Enhance your database engineering knowledge and gain a thorough understanding of PostgreSQL's inner workings to optimize your database implementations.

Intro
Overview
Postgres MVCC
Processes vs Threads
Postmaster Process
Backend Processes
Shared Buffers
Background Workers
Auxiliary Processes
Background Writer
Checkpointer
Logger
Autovacuum Launcher and Workers
WAL Processes
Startup Process