postgresql-optimization

PostgreSQL query optimization uses EXPLAIN ANALYZE to dissect slow SQL execution plans, identifying bottlenecks like sequential scans or missing indexes. This Skill analyzes those plans and recommends targeted improvements such as index additions or SQL rewrites for faster results.

JSONB and array types in PostgreSQL enable efficient complex data modeling by storing semi-structured and multi-value data natively. This Skill demonstrates how to leverage these advanced types alongside range and geometric types for optimized data management.

Partial and expression indexes are needed for PostgreSQL performance tuning when queries frequently filter on specific subsets of data or computed values. This Skill recommends effective indexing strategies, including composite, partial, expression, and covering indexes tailored to your query patterns.

PostgreSQL connection management and memory settings directly impact database performance by controlling resource allocation and concurrent query handling. This Skill provides expert guidance on tuning these configurations and utilizing extensions for efficient data management.

PostgreSQL window functions and full-text search improve report generation by enabling complex analytical aggregations and rapid text querying directly within the database. This Skill shows how to implement these features to optimize slow reporting workflows.