postgres-expert

To optimize PostgreSQL query performance, analyze execution plans and apply advanced indexing or partitioning strategies to manage large datasets and reduce latency. Recommendations include concrete steps with measurable success criteria and validation methods.

Indexing JSONB columns in PostgreSQL requires specialized strategies like appropriate path query indexing to optimize complex operations. The skill provides targeted JSONB optimization steps to ensure low latency and reliable data retrieval.

PgBouncer aids PostgreSQL connection management by pooling connections, reducing overhead in high-traffic production databases. This skill provides connection management and replication tuning steps to ensure scalable and reliable database performance.

You need PostgreSQL partitioning strategies when managing large datasets that degrade query performance. This skill identifies bottlenecks and provides advanced partitioning plans with actionable steps to maintain low latency at scale.

Tune PostgreSQL autovacuum and perform health checks by following targeted maintenance plans to manage vacuum operations effectively. This skill outlines concrete maintenance steps to ensure ongoing database reliability and performance.

PostgreSQL replication lag occurs due to misconfigured replication setups or unoptimized queries. This skill identifies performance bottlenecks across replication and provides a scalable plan with actionable tuning steps to resolve latency.