PostgreSQL Best Practices

Comprehensive PostgreSQL reference consolidating performance optimization (Supabase), common patterns, and schema design guidance. Covers 8 rule categories prioritized by impact, plus detailed data type and table design reference.

When to Use

Reference these guidelines when:

• Writing SQL queries, migrations, or designing schemas
• Implementing indexes or query optimization
• Reviewing database performance issues
• Configuring connection pooling or scaling
• Optimizing for Postgres-specific features
• Working with Row-Level Security (RLS)
• Choosing data types, constraints, or table structures
• Troubleshooting slow queries

Rule Categories by Priority