supabase-postgres-best-practices

Supabase 提供的 Postgres 性能与最佳实践指南。

一套由 Supabase 汇总的 Postgres 性能优化与最佳实践指南，覆盖查询、索引、schema 设计和数据库配置等面向性能的规则。写 SQL、设计表结构或排查慢查询、优化性能时用。特点是按影响力优先排序，方便把精力投在最能提速的点上。

# Supabase Postgres Best Practices

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.

## When to Apply

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)

## Rule Categories by Priority

| Priority | Category | Impact | Prefix |
|----------|----------|--------|--------|
| 1 | Query Performance | CRITICAL | `que