Identifying time-consuming queries using tools like pg_stat_statements or pgBadger . The Life of a PostgreSQL Table, Part 2 with Bruce Momjian
For foundational concepts, his book PostgreSQL: Introduction and Concepts provides a detailed historical and technical overview of the system. Core Administration Topics Covered Mastering PostgreSQL Administration - Bruce Mom...
The official Mastering PostgreSQL Administration guide includes deep dives into installation, configuration, maintenance, monitoring, and recovery. Mastering PostgreSQL Administration - Bruce Mom...
Starting and stopping the postmaster, and managing data directory structures. Mastering PostgreSQL Administration - Bruce Mom...
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.