skills.rest
VanhPoker
VanhPokerCOMMUNITY
Explore all skills by this author →
GitHub

postgres-expert

Diagnose PostgreSQL performance bottlenecks across configuration, indexing, and query patterns.

Updated Jan 17, 2026
Search Tags:#indexing#database#postgresql#partitioning#query-optimization#jsonb#autovacuum
One-click install
npx skills add https://github.com/VanhPoker/VietNamLookmaxing --skill postgres-expert-vanhpoker
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/VanhPoker/VietNamLookmaxing/tree/main/.agent/skills/postgres-expert
Command: npx skills add https://github.com/VanhPoker/VietNamLookmaxing --skill postgres-expert-vanhpoker

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL performance can degrade due to suboptimal queries, poor indexing, and misconfigured settings; this skill provides a structured approach to diagnosing and tuning PostgreSQL for faster queries and reliable operation.

Core Features & Use Cases

  • Deep-dive environment assessment: version, configuration, extensions, and health checks to identify bottlenecks.
  • Advanced optimization techniques: indexing strategies (B-tree, GIN for JSONB, partial indexes), partitioning, autovacuum tuning, and WAL/configuration tuning for throughput.
  • Problem-oriented workflows: from query performance analysis to replication/HA, with step-by-step guidance for production-grade deployments.

Quick Start

Run a targeted PostgreSQL analysis to identify slow queries, missing indexes, and configuration opportunities, then apply recommended tuning steps.

Frequently Asked Questions about postgres-expert

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

FAQPage Schema
How do I identify PostgreSQL performance bottlenecks in a production database?▼

Identify PostgreSQL performance bottlenecks by running a deep-dive environment assessment that checks version configurations, extensions, and query patterns to pinpoint slow queries and misconfigurations.

What is the best way to optimize PostgreSQL indexing for JSONB data?▼

Optimize PostgreSQL JSONB indexing by applying targeted strategies like GIN indexes for JSONB documents and partial indexes, ensuring faster query retrieval on complex JSON structures.

How does autovacuum tuning improve PostgreSQL query performance?▼

Autovacuum tuning improves PostgreSQL performance by adjusting configuration settings to manage bloat and transaction overhead, ensuring reliable operation and sustained query throughput.

When do I need table partitioning for PostgreSQL optimization?▼

Table partitioning is needed for PostgreSQL optimization when managing large datasets that cause query degradation, allowing targeted techniques to distribute data and improve access speed.

Can I use this PostgreSQL optimization approach for replication and high availability setups?▼

Yes, this approach provides problem-oriented workflows that include step-by-step diagnostic guidance for replication and high availability in production-grade PostgreSQL deployments.

What PostgreSQL configuration settings should I check for WAL optimization?▼

Check PostgreSQL configuration settings related to WAL and general throughput tuning to identify misconfigurations and apply safe-change practices for optimized production performance.

Related Skills

Explore More Software Engineering Skills→
scanadyscanady

tech-database-optimizer

Analyze PostgreSQL and MySQL EXPLAIN ANALYZE outputs to diagnose database bottlenecks.

Community
Advanced
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
BradliebsBradliebs

canary

Monitor live web apps for console errors, performance regressions, and visual anomalies.

Community
Advanced
newkayak12newkayak12
1

database-optimizer

Analyze EXPLAIN ANALYZE output to optimize PostgreSQL and MySQL queries.

Community
Advanced