PlanetScale Postgres

Generic Postgres

Topic Reference Use for

Schema Design references/schema-design.md Tables, primary keys, data types, foreign keys

Indexing references/indexing.md Index types, composite indexes, performance

Index Optimization references/index-optimization.md Unused/duplicate index queries, index audit

Partitioning references/partitioning.md Large tables, time-series, data retention

Query Patterns references/query-patterns.md SQL anti-patterns, JOINs, pagination, batch queries

Optimization Checklist references/optimization-checklist.md Pre-optimization audit, cleanup, readiness checks

MVCC and VACUUM references/mvcc-vacuum.md Dead tuples, long transactions, xid wraparound prevention

Operations and Architecture

Topic Reference Use for

Process Architecture references/process-architecture.md Multi-process model, connection pooling, auxiliary processes

Memory Architecture references/memory-management-ops.md Shared/private memory layout, OS page cache, OOM prevention

MVCC Transactions references/mvcc-transactions.md Isolation levels, XID wraparound, serialization errors

WAL and Checkpoints references/wal-operations.md WAL internals, checkpoint tuning, durability, crash recovery

Replication references/replication.md Streaming replication, slots, sync commit, failover

Storage Layout references/storage-layout.md PGDATA structure, TOAST, fillfactor, tablespaces, disk mgmt

Monitoring references/monitoring.md pg_stat views, logging, pg_stat_statements, host metrics

Backup and Recovery references/backup-recovery.md pg_dump, pg_basebackup, PITR, WAL archiving, backup tools

PlanetScale-Specific

Topic Reference Use for

Connection Pooling references/ps-connection-pooling.md PgBouncer, pool sizing, pooled vs direct

Extensions references/ps-extensions.md Supported extensions, compatibility

Connections references/ps-connections.md Connection troubleshooting, drivers, SSL

Insights references/ps-insights.md Slow queries, MCP server, pscale CLI

CLI Commands references/ps-cli-commands.md pscale CLI reference, branches, deploy requests, auth

CLI API Insights references/ps-cli-api-insights.md Query insights via pscale api , schema analysis