Professional Validation Library

Why Is the Database Slow? · Kai London

PostgreSQL Performance Incident Laboratory: Diagnose Query, Locking, Capacity and Regression Failures in PostgreSQL

The database slowed down at peak. Do you know whether locking, queries or capacity caused it?

When a PostgreSQL database slows down, teams often argue about causes before anyone has evidence. This book gives database engineers and operations teams a repeatable way to diagnose slow queries, lock contention, connection exhaustion, bloat and capacity limits, and to prove that a fix worked.

Part I is the practitioner guide. It covers a diagnosis method, lab set-up, reading query plans, indexes, locking, connections, memory and I/O, vacuum and bloat, regressions after change, capacity, and a chapter of 25 incident cases. Part II is the field toolkit: three labs that build a reference incident lab, inject faults and automate regression detection, three extended case studies, annotated templates explained field by field, a maturity model, a metrics pack, a 30/60/90-day roadmap and a question bank.

Part III is reference and practice. It provides incident registers, policy and runbook templates, report and handover formats, exercise workbooks with model answers, tabletop scenarios, a standards crosswalk, a tooling evaluation guide and a glossary. Part IV is an evidence casebook of worked cases, including a full WAL volume that stopped dispatch and a slowdown that spread across three regions. Appendix A supplies checklists for use during live incidents.

This is an independent practitioner reference, not an official guide of any vendor or standards body. It is written for database administrators, site reliability engineers, platform engineers, performance testers and the managers who review their work.

Every chapter is built for working professionals: a real headline, a dramatised boardroom scene, decision tables, worked examples with expected results, the evidence to keep, a checklist, the board question and a self-test. The book closes with a capstone assessment, consolidated checklists, model answers, a standards crosswalk, a certification domain map for CISSP, CISM, CRISC and CISA, and a full index.

Professor Kai London