postgres-perf
kjaylee tarafından
Coding Agents & IDEsÖzet
PostgreSQL performance optimization and best practices.
Açıklama
Bu Beceri Ne Yapar
A reference guide for PostgreSQL query optimization, schema design, connection management, and Row Level Security. Covers indexing strategies, N+1 query patterns, and concurrency best practices. Based on Supabase postgres-best-practices.
Combines query tuning, schema decisions, and connection pooling guidance in one place rather than spread across separate Postgres and Supabase docs.
Ne Zaman Kullanılır
- Diagnosing slow queries with EXPLAIN ANALYZE
- Adding partial indexes for filtered queries
- Replacing N+1 queries with JOINs
- Configuring pgBouncer for serverless environments
- Writing RLS policies without hurting performance
Örnek İş Akışı
User asks: why is my orders query slow on a 2M row table?
- 1
Run EXPLAIN ANALYZE on the slow query to read the execution plan
- 2
Identify Seq Scan on customer_email column
- 3
Generate CREATE INDEX idx_orders_email ON orders(customer_email)
- 4
Re-run EXPLAIN ANALYZE to confirm Index Scan is used
- 5
Check if SELECT * can be narrowed to required columns only
Index created, query switches from Seq Scan to Index Scan, execution time drops significantly
Kurulum
clawhub install kjaylee/postgres-perfCLI komutunu çalıştırın ya da istemi Claude Code, Cursor, Codex veya kullandığınız kodlama ajanına yapıştırın.