supabase-postgres-best-practices

Optimize slow Postgres queries in Supabase by analyzing query plans with EXPLAIN ANALYZE and applying targeted indexing patterns. This skill provides rules for index selection, batching, and pagination to resolve performance bottlenecks.

Choosing Postgres index types for Supabase schemas involves selecting between btree, gin, gist, and brin indexes. This skill provides concrete rules for applying composite, partial, and covering indexes to match your query patterns.

Row Level Security (RLS) impacts Supabase Postgres performance by adding overhead to query execution. This skill provides RLS performance tips and security considerations to maintain database speed while enforcing access control.

Maintain a production Postgres database in Supabase by running VACUUM and ANALYZE operations and monitoring with pg_stat_statements. This skill outlines maintenance and observability patterns to ensure long-term reliability.

Fix N+1 query problems in a Supabase Postgres backend by applying query optimization patterns like batching and upserting. This skill provides example-driven rules to restructure queries and control concurrency efficiently.

Partial and covering indexes improve Supabase query speed by indexing only relevant subsets of data and including extra columns to avoid table lookups. This skill explains when to apply these indexing patterns for optimal results.