How Not to 'Sleep Through' Problems in Postgres Databases
summary
Covers performing regular PostgreSQL health checks and technical audits to find early symptoms of problems in production databases. Describes practical inspections and diagnostic steps to keep Postgres instances healthy by probing internal state and metrics rather than waiting for failures.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 3:59Data health problems
- 10:24Monitoring limitations
- 13:15Check-up tool: idea and requirements
- 16:30Check-up in practice
- 20:20Reports: structure and automation
- 23:10Master versus replicas
- 26:34Postgres versions and extensions
- 29:40Filesystem and configuration
- 31:27Table and index bloat
- 39:10Query analysis: metrics and groups
- 45:11Final reports and conclusions
- 47:18Q&A
related talks
45mPostgreSQL monitoring fundamentals
45mDebugging Databases for Developers
01h 00mThe 10 Deadly PostgreSQL Sins
37mWhen it all goes Wrong (with Postgres)
46mHow PostgreSQL Can Hurt You When You Least Expect It
39mDeep dive into PostgreSQL internal statistics
11mThe Seven Principles for Making a PostgreSQL DB Work Fast
20mDebugging Data Corruption in PostgreSQL