PostgreSQL Operations
PostgreSQL Production Care
Tuition reference: 1,320,000 KRW
Vacuum strategy, connection storms, and extension hygiene framed for operators who inherited older clusters.
Overview
Labs rotate through pg_stat views, autovacuum tuning exercises, and extension audits on purposefully messy sample clusters. You practice writing concise handover notes after each lab block.
Included focus areas
- pg_stat_activity interpretation drills
- Autovacuum threshold experiments on sample data
- Extension allow-list policy drafting
- Connection pooler sidecar walkthrough
- Handover note template used after each lab
Outcomes you can evidence
- Plan maintenance windows with documented checklists.
- Explain architecture choices to peers using diagrams you produce in class.
- Ship a capstone lab report reviewers can follow without extra clarification.
Primary mentor
Hina Okada
Senior database instructor with multi-vendor production background and mentor hours for cohort labs.
Learner notes
I liked that the messy inherited cluster storyline matched what I see at work. The extension audit felt immediately usable.
Workload storylines felt grounded; I would have liked one more async block on WAL sizing.
Common questions
We introduce concepts and risks; a deep replication engineering course is a separate advanced offering.