Index strategies we rehearse in the PostgreSQL intensive

Partial indexes rarely appear in beginner tutorials, yet they dominate real-world tuning conversations in Ho Chi Minh operations centers. In the PostgreSQL Administration Intensive, learners build a delayed replica sandbox, then attach partial indexes tied to realistic status columns such as shipment states or KYC verification flags.

We ask cohort members to pair on documentation: English for engineering partners abroad, Vietnamese summaries for internal policy teams. The goal is not a perfect index for every query—it is a repeatable decision record showing which predicates motivated the partial filter and what monitoring will catch drift.

During mentor reviews, we stress honest limitations. Partial indexes fail when application code silently broadens predicates or when ORM layers generate dynamic SQL that bypasses the intended filter. Learners must write rollback steps before applying changes in their employer sandboxes.

By week three, each participant presents a before-and-after explain plan with commentary on cardinality estimates. The presentation format mirrors what hiring managers request: concise, evidence-based, and willing to disclose unknowns rather than implying guaranteed performance wins.