Optimizes PostgreSQL database performance through advanced indexing, query plan analysis, partitioning, and connection pooling.
This skill equips Claude with specialized knowledge for fine-tuning PostgreSQL databases to handle high loads and complex queries. It provides implementation patterns for various indexing strategies (including GIN and GiST), instructions for interpreting query plans using EXPLAIN ANALYZE, and configurations for connection pooling with PgBouncer. Whether you're dealing with slow-performing JSONB operations or tables exceeding 10 million rows that require partitioning, this toolkit offers the domain-specific guidance needed to eliminate bottlenecks and ensure database scalability.
주요 기능
01In-depth query plan analysis using EXPLAIN ANALYZE to identify sequence scans and bottlenecks.
02Implementation of advanced indexing strategies like partial, composite, and covering indexes.
030 GitHub stars
04Performance-oriented JSONB query and update optimization techniques.
05Table partitioning patterns for managing large-scale datasets efficiently.
06Connection pooling configuration and server tuning parameters for high-concurrency environments.
사용 사례
01Designing a scalable database schema for high-growth applications with millions of rows.
02Optimizing database connection management and server resource utilization for high-traffic apps.
03Troubleshooting and fixing slow-running SQL queries in a production environment.
