supabase-postgres-best-practices

Topics in the source

• Supabase Postgres Best Practices
• When to Apply
• Rule Categories by Priority
• How to Use
• Full Compiled Document

Comprehensive performance optimization guide for Postgres, maintained by Supabase. Contains rules across 8 categories, prioritized by impact to guide automated query optimization and schema design. Reference these guidelines when: Writing SQL queries 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) | Priority | Category | Impact | Prefix | |----------|----------|--------|--------| | 1 | Query Performance | CRITICAL | query- | | 2 | Connection Management | CRITICAL | conn- | | 3 | Security & RLS | CRITICAL | security- | | 4 | Schema Design | HIGH | schema- | | 5 | Concurrency & Locking | MEDIUM-HIGH | lock- | | 6 | Data Access Patterns | MEDIUM | data- | | 7 | Monitoring & Diagnostics | LOW-MEDIUM | monitor- | | 8 | Advanced Features | LOW | advanced- | Read individual rule files for detailed explanations and SQL examples: Each rule file contains: Brief explanation of why it matters Incorrect SQL example with explanation Correct SQL example with explanation Optional EXPLAIN output or metrics Additional context

This is an excerpt. Refer to the complete source and its current requirements.