---
name: postgres-mastery
description: "Advanced PostgreSQL — index strategies, EXPLAIN ANALYZE, partitioning, pgvector, connection pooling, zero-downtime migrations, backups, and replication. Use when diagnosing slow queries, designing indexes, planning a migration, tuning PgBouncer, adding pgvector search, or setting up backups/replication."
---
# PostgreSQL Mastery

Production PostgreSQL patterns that go beyond `CREATE INDEX`. Index selection, query plan analysis, partitioning, pgvector for embeddings, zero-downtime migrations, and replication.

---

## Reference guide

Read only the references needed for the current request:

- **1. Index Types — When to Use Each**: [references/1-index-types-when-to-use-each.md](references/1-index-types-when-to-use-each.md)
- **2. EXPLAIN ANALYZE Deep Dive**: [references/2-explain-analyze-deep-dive.md](references/2-explain-analyze-deep-dive.md)
- **3. Partitioning**: [references/3-partitioning.md](references/3-partitioning.md)
- **4. pgvector — Embeddings & Similarity Search**: [references/4-pgvector-embeddings-similarity-search.md](references/4-pgvector-embeddings-similarity-search.md)
- **5. Connection Pooling — PgBouncer**: [references/5-connection-pooling-pgbouncer.md](references/5-connection-pooling-pgbouncer.md)
- **6. Zero-Downtime Migrations**: [references/6-zero-downtime-migrations.md](references/6-zero-downtime-migrations.md)
- **7. Backup & Recovery**: [references/7-backup-recovery.md](references/7-backup-recovery.md)
- **8. Replication**: [references/8-replication.md](references/8-replication.md)
- **9. Query Optimization Case Studies**: [references/9-query-optimization-case-studies.md](references/9-query-optimization-case-studies.md)
- **10. Essential Configuration**: [references/10-essential-configuration.md](references/10-essential-configuration.md)