Database Operations · PostgreSQL
Day-Two PostgreSQL Operations
Six weeks for operators who already deploy PostgreSQL and now have to keep it healthy through patch days, table bloat, and the slow drift of running systems.
About this cohort
Day-Two is the second life of any database — the part nobody trains you for. You will rehearse minor and major version upgrades against a running replica, learn to read pg_stat_activity without panic, and design vacuum schedules that respect both autovacuum and the realities of overnight ETL. The cohort culminates in a production drill: you are paged at 22:00 with a degraded replica and walk through the incident with a mentor watching your terminal share. We also cover the small operational rituals — runbook hygiene, documentation that other people will read at 03:00, and the etiquette of writing useful incident records.
Inclusions
- Hands-on patch and pg_upgrade walk-throughs on disposable replicas
- Custom autovacuum tuning worksheet for your own workload shape
- Three timed incident drills with mentor commentary
- Recipes for monitoring with Prometheus exporters and pgBadger
- Template incident records and post-mortem outline used in the field
- Lab access to a write-heavy synthetic workload generator
- A weekly readings circle on the PostgreSQL release notes
By the end you can
- 01 Run a minor and a major PostgreSQL upgrade end to end on your own
- 02 Diagnose lock contention from pg_locks and write a clear incident note
- 03 Tune autovacuum parameters for a write-heavy table without guessing
Programme lead
Park Jihoon
Database Lab Engineer who maintains the cohort sandboxes. He breaks our clusters on purpose so participants can practice repairing them.
Common questions
From the cohort
-
The incident drill in week five mirrored an outage we had two months earlier. Different cause, same shape. I rewrote our runbook the same evening.
Jae-wonJae-won
Operations Lead · mid-size SaaS 4.8/5
-
Strong on autovacuum, lighter on monitoring tooling than I hoped. Mentor still pointed me at useful follow-up reading.
Eun-byulEun-byul
4.5/5 · Google
-
Genuinely the first course where I felt the labs respected my time. No filler exercises.
Operator at a logistics platformOperator at a logistics platform