postgres-best-practices

A collection of Postgres optimization rules organized by impact, covering query performance, connection management, RLS, schema design, and concurrency. Each rule includes SQL examples showing the wrong and right approach, with EXPLAIN output and metrics where relevant. Maintained by Supabase, but applies to any Postgres setup. Instead of piecing together Postgres tuning advice from scattered blog posts, you get prioritized rules with concrete SQL examples and measurable performance impact in one place.