The official Mastering PostgreSQL Administration guide includes deep dives into installation, configuration, maintenance, monitoring, and recovery.
The primary resource for this topic is , a comprehensive 117-page guide that covers advanced administrative tasks. This document is frequently updated and serves as the core "paper" or slide deck for his professional training sessions. Key Resources by Bruce Momjian Mastering PostgreSQL Administration - Bruce Mom...
Identifying time-consuming queries using tools like pg_stat_statements or pgBadger . The Life of a PostgreSQL Table, Part 2 with Bruce Momjian Write-Ahead Logs (WAL)
You can find the full collection of his Postgres Administration Presentations on his personal site, including video recordings from major conferences like PGConf and FOSDEM. and MVCC (Multi-Version Concurrency Control).
A curated collection of the most impactful slides from over 25 years of PostgreSQL presentations.
The "Mastering" guide specifically addresses these critical areas:
Understanding vacuuming operations, Write-Ahead Logs (WAL), and MVCC (Multi-Version Concurrency Control).