Intermediate
Indexing and Query Shapes
Design indexes that survive ORMs and ad-hoc reporting. You will learn to prototype alternative shapes, validate with realistic cardinality, and communicate trade-offs to product squads.
Duration: 4 weeks · 34 hours · Format: Cohort with weekly code reviews
Price (informational): ￥156,000
Request information
What is included
- Partial indexes tied to real access paths
- INCLUDE columns versus wide indexes
- Hash versus btree when legality matters
- BRIN for append-heavy facts (where appropriate)
- Detecting redundant indexes safely
- Collaborative review template for schema proposals
Outcomes
- Ship an index proposal with measured write amplification
- Remove a redundant index with rollback steps
- Pair with app team on pagination pattern fixes
Lead contact
Aya Morimoto
Performance coach for product teams shipping on Postgres.
FAQ
We reference Django and Prisma patterns, but focus stays engine-level.
Labs assume NVMe-backed dev machines. HDD-only hosts are not simulated.
No deep columnar store tuning; we mention Citus only as orientation.
Participant notes
INCLUDE column lab shaved 40% buffer hits on our invoice search. Write-up went straight to RFC comments.
Ryo · Trustpilot