7 open lessons · primer to advanced
The PostgreSQL administration library.
Start with the maintenance loops that keep PostgreSQL correct, then move through evidence, workload, locks, vacuum, indexes, and replication.
Follow the six-module master journey →- 01How PostgreSQL stays healthyA working model of backends, shared memory, WAL, checkpoints, vacuum, and the statistics that connect them.
- 02Observability before optimisationLearn how to distinguish current activity, cumulative history, logs, and operating-system evidence.
- 03Reading query workload with pg_stat_statementsRank statements by total load, latency, calls, I/O, and temporary work without mistaking a fingerprint for a plan.
- 04Locks, blockers, and wait eventsRead a blocking chain, identify its root, and choose a response based on impact and transaction ownership.
- 05Vacuum, bloat, and transaction ID ageUnderstand row-version cleanup, freezing, vacuum capacity, and why file size does not shrink after routine vacuum.
- 06Indexes as a workload trade-offEvaluate indexes as structures that exchange storage and write work for selective access paths.
- 07Replication, WAL, and lagSeparate WAL generation, transport, flush, and replay so a lag number becomes a diagnosable pipeline.