postgres-expert

What problem does it solve?

This skill provides expert-level PostgreSQL optimization, indexing, and administration capabilities to maximize performance and reliability.

Core Features & Use Cases

• Query optimization: Identify and optimize slow queries, tune planner settings, and build effective indexes.
• JSONB optimization: Create and manage JSONB indexes, optimize JSONPath queries, and implement efficient data access patterns.
• Partitioning and maintenance: Implement time-based partitioning, manage autovacuum tuning, and maintain large datasets efficiently.
• Use Case: A production PostgreSQL cluster with heavy analytic workloads requiring fast query times and robust data governance.

Quick Start

Run targeted PostgreSQL diagnostics, then apply indexing and partitioning recommendations across the database to improve performance.