PostgreSQL

Schema and Data Modeling

| Topic | Reference | Use for | | -------------- | ---------------------------------------------------------- | ------------------------------------------------------ | | Schema Design | references/schema-design.md | Tables, primary keys, data types, foreign keys, naming | | JSONB Patterns | references/json-patterns.md | JSONB operators, querying, indexing, best practices | | Partitioning | references/partitioning.md | Range/list partitioning, pg_partman, data retention |

Querying and Optimization

| Topic | Reference | Use for | | ---------------------- | ---------------------------------------------------------------------------- | -------------------------------------------------------- | | Query Patterns | references/query-patterns.md | SQL anti-patterns, JOINs, pagination, N+1 detection | | Indexing | references/indexing.md | Index types, composite, partial, covering, GIN, BRIN | | Index Optimization | references/index-optimization.md | Unused/duplicate index detection, bloat, HOT updates | | Full-Text Search | references/full-text-search.md | tsvector, tsquery, GIN indexing, ranking, search config | | Optimization Checklist | references/optimization-checklist.md | Pre-optimization audit, cleanup, readiness checks |

Internals and Concurrency

| Topic | Reference | Use for | | ----------------- | ------------------------------------------------------------------ | ------------------------------------------------------ | | MVCC and VACUUM | references/mvcc-vacuum.md | Dead tuples, autovacuum tuning, bloat prevention | | MVCC Transactions | references/mvcc-transactions.md | Isolation levels, XID wraparound, serialization errors | | Locking | references/locking.md | Lock types, deadlocks, advisory locks, lock monitoring |

Operations and Architecture

| Topic | Reference | Use for | | -------------------- | -------------------------------------------------------------------------- | --------------------------------------------------------------- | | Process Architecture | references/process-architecture.md | Multi-process model, connection management, auxiliary processes | | Memory Architecture | references/memory-management-ops.md | Shared/private memory, OS page cache, OOM prevention | | WAL and Checkpoints | references/wal-operations.md | WAL internals, checkpoint tuning, durability, crash recovery | | Storage Layout | references/storage-layout.md | PGDATA structure, TOAST, fillfactor, tablespaces | | Replication | references/replication.md | Streaming replication, slots, sync commit, failover | | Backup and Recovery | references/backup-recovery.md | pg_dump, pg_basebackup, PITR, WAL archiving |

Configuration and Tuning

| Topic | Reference | Use for | | -------------------- | ------------------------------------------------------------------------ | -------------------------------------------------------- | | Configuration Tuning | references/configuration-tuning.md | Memory, I/O, planner, parallelism, workload profiles | | Connection Pooling | references/connection-pooling.md | PgBouncer setup, pool sizing, pooling modes | | Monitoring | references/monitoring.md | pg_stat views, logging, pg_stat_statements, host metrics |

Framework Integration

| Topic | Reference | Use for | | ------------------ | ------------------------------------------------------------------------ | ---------------------------------------------------------------- | | Django Integration | references/django-integration.md | ORM optimization, connection pooling, zero-downtime migrations, contrib.postgres |

Security and Migrations

| Topic | Reference | Use for | | ----------------- | ------------------------------------------------------------------ | --------------------------------------------------------- | | Security | references/security.md | Roles, permissions, RLS, pg_hba.conf, SSL/TLS, audit | | Schema Migrations | references/schema-migrations.md | Zero-downtime DDL, safe migration patterns, backfills | | Extensions | references/extensions.md | pg_stat_statements, pgcrypto, PostGIS, pg_repack, pgAudit |