skills.rest
phuxp17
phuxp17COMMUNITY
Explore all skills by this author →
GitHub

postgres-expert

Optimize PostgreSQL performance through query tuning, indexing, and configuration adjustments.

Updated Aug 27, 2026
Search Tags:#performance#indexing#postgresql#partitioning#jsonb#pgbouncer
One-click install
npx skills add https://github.com/phuxp17/demo_web --skill postgres-expert-phuxp17
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/phuxp17/demo_web/tree/main/.agent/skills/postgres-expert
Command: npx skills add https://github.com/phuxp17/demo_web --skill postgres-expert-phuxp17

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps database teams optimize PostgreSQL performance and reliability through targeted query tuning, indexing strategies, and robust configuration.

Core Features & Use Cases

  • Query performance tuning: identify bottlenecks and apply index and planner settings.
  • JSONB optimization: design appropriate GIN indexes and effective queries.
  • Partitioning and replication: implement partitions and replica setups for scale and availability.
  • Connection management: configure pooling (PgBouncer) to handle high-concurrency workloads.

Quick Start

Initiate a performance optimization session by profiling slow queries with pg_stat_statements, applying baseline indexing and vacuum adjustments, and validating changes against a tested backup plan.

Frequently Asked Questions about postgres-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL queries using pg_stat_statements?▼

To optimize slow PostgreSQL queries, profile them with pg_stat_statements to identify bottlenecks, then apply baseline indexing and planner setting adjustments to improve execution speed.

What is the best way to index JSONB workloads in PostgreSQL?▼

The best way to index JSONB workloads is designing appropriate GIN indexes and effective queries, allowing you to optimize JSONB performance for complex document data retrieval.

How does PgBouncer connection pooling handle high-concurrency PostgreSQL workloads?▼

PgBouncer connection pooling handles high-concurrency PostgreSQL workloads by managing and configuring connection pooling, reducing database overhead and maintaining reliable connection throughput.

When do I need partitioning and replication for PostgreSQL?▼

You need partitioning and replication for PostgreSQL to implement partitions and replica setups for scale and availability, managing large datasets and ensuring high data reliability.

Can I safely tune autovacuum settings without risking transactional changes?▼

You can safely tune autovacuum settings when paired with safe maintenance routines and backup validation, ensuring transactional changes are validated against a tested backup plan.

Related Skills

Explore More Software Engineering Skills→
afonsoftafonsoft
1

sql-optimization

Optimize SQL queries and indexing across MySQL, PostgreSQL, SQL Server, and Oracle.

Community
Advanced
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
hung-phanhung-phan

connection-pooling

Configure and monitor SQL database connection pools to reduce connection overhead.

Community
Advanced
jscott3201jscott3201
2

perf-profile

Profile Rust, Python, and JavaScript code to resolve performance regressions.

Community
Advanced