PostgreSQL Operations
Performance Diagnostics Wait Lab
Tuition reference: 760,000 KRW
Wait statistics reading club style: short bursts of observation, longer debriefs, zero dashboard cosplay.
Overview
We avoid vanity metric walls. Instead you collect short observation windows, cluster findings, and propose the next diagnostic step with rationale. Labs emphasize PostgreSQL and SQL Server samples.
Included focus areas
- Observation window timer discipline
- Wait stats interpretation flash cards
- Cross-engine compare sheet
- Debrief facilitation prompts
- Capstone diagnostic memo with peer markup
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
Minseo Park
Senior database instructor with multi-vendor production background and mentor hours for cohort labs.
Learner notes
Wait stats flash cards felt nerdy until they saved a triage call last month.
Common questions
Not covered; focus remains CPU, IO, and concurrency patterns for relational engines.