postgresql-indexing

What problem does it solve?

This Skill provides guidance and best practices for designing, validating, and maintaining PostgreSQL indexes to ensure optimal query performance and database efficiency.

Core Features & Use Cases

• Index Design: Learn best practices for column order, partial indexes, and avoiding common pitfalls.
• Performance Validation: Understand how to use EXPLAIN ANALYZE and other tools to verify index effectiveness.
• Maintenance & Optimization: Discover strategies for identifying unused indexes, managing bloat, and reindexing.
• Use Case: A developer is experiencing slow query performance on a PostgreSQL database and needs to understand if their current indexes are optimal or if new ones are needed.

Quick Start

Use the postgresql-indexing skill to learn about creating partial indexes for better performance.