कंटेंट पर जाएँ
TakoAPI
स्किल्स पर वापस
—अभी तक कोई रेटिंग नहीं
आपकी रेटिंग

संक्षिप्त

PostgreSQL performance optimization and best practices.

विवरण

यह स्किल क्या करती है

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.

इसे कब इस्तेमाल करें

  • 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

उदाहरण वर्कफ़्लो

इनपुट

User asks: why is my orders query slow on a 2M row table?

एजेंट
  1. 1

    Run EXPLAIN ANALYZE on the slow query to read the execution plan

  2. 2

    Identify Seq Scan on customer_email column

  3. 3

    Generate CREATE INDEX idx_orders_email ON orders(customer_email)

  4. 4

    Re-run EXPLAIN ANALYZE to confirm Index Scan is used

  5. 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

इंस्टॉलेशन

clawhub install kjaylee/postgres-perf

CLI कमांड चलाएँ, या प्रॉम्प्ट को Claude Code, Cursor, Codex या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।

लिंक