#postgresql

Analyze and optimize PostgreSQL query performance. Steps: 1. Identify slow queries with pg_stat_statements. 2. Analyze Execution plans (EXPLAIN ANALYZE). 3. Create covering indexes for frequent queries. 4. Optimize JOIN operations. 5. Vacuum and analyze strategy. 6. Partition large tables. 7. Tune configuration parameters (work_mem, shared_buffers). 8. Connection pooling setup (PgBouncer). Include index maintenance plan.

Build with Supabase as backend. Features: 1. PostgreSQL database with REST API. 2. Auto-generated APIs from schema. 3. Authentication (email, OAuth, magic links). 4. Row-level security policies. 5. Real-time subscriptions. 6. Storage for files. 7. Edge functions for serverless. 8. TypeScript SDK. Use supabase.from() for queries and implement triggers for complex logic.