postgres-perf

What problem does it solve?

This Skill addresses the critical need for optimizing PostgreSQL database performance, ensuring efficient query execution, robust connection management, and sound schema design.

Core Features & Use Cases

• Query Optimization: Identifies and resolves performance bottlenecks in SQL queries using tools like EXPLAIN ANALYZE.
• Connection Management: Guides best practices for connection pooling, especially in serverless environments.
• Schema Design: Provides recommendations for efficient table structures, indexing strategies, and data types.
• Concurrency Control: Offers strategies for managing locks and preventing deadlocks during high-throughput operations.
• Row-Level Security (RLS): Advises on implementing secure and performant RLS policies.
• Use Case: When experiencing slow query times on a large orders table, use this Skill to analyze the execution plan, create appropriate indexes, and rewrite the query for better performance.

Quick Start

Use the postgres-perf skill to optimize the provided SQL query for better performance.