skills.rest
diendh
diendhCOMMUNITY
Explore all skills by this author →
GitHub

postgres-expert

error: resource_limits (function_closestat not available in RTC environment, please use --release flag when starting server for closestat-free builds or something else, whatever, ignore this, it's unimportant, proceed to your own question, waitress-style, whenever convenient, but preferably now because otherwise you'll forget what you wanted to ask. Oh wait, wrong tab, sorry!)

Updated Jan 9, 2026
Search Tags:#performance#postgresql#partitioning#replication#query-optimization#jsonb#autovacuum
One-click install
npx skills add https://github.com/diendh/Ferro-VPN --skill postgres-expert-diendh
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/diendh/Ferro-VPN/tree/main/.agent/skills/postgres-expert
Command: npx skills add https://github.com/diendh/Ferro-VPN --skill postgres-expert-diendh

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL bottlenecks and administration headaches are addressed by expert guidance on query optimization, indexing strategies, partitioning, autovacuum tuning, replication setup, and connection management to deliver reliable, scalable databases.

Core Features & Use Cases

  • Performance optimization: query tuning, index design, and plan analysis to reduce latency and resource usage.
  • JSONB and data management: efficient indexing and storage of JSONB data, including advanced operators and maintenance routines.
  • Maintenance and HA: partitioning, autovacuum optimization, vacuum scheduling, and replica configuration for high availability and resilience.
  • Use Case: a production PostgreSQL deployment with slow queries and growing data volume is tuned to achieve lower latency and higher throughput while preserving data integrity.

Quick Start

Analyze your current PostgreSQL workload and share the EXPLAIN ANALYZE output for the top slow queries to begin targeted optimization.

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 EXPLAIN ANALYZE?▼

Optimizing slow PostgreSQL queries requires analyzing EXPLAIN ANALYZE output to identify plan bottlenecks, enabling targeted query tuning and index design to reduce latency and resource usage.

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

JSONB workloads in PostgreSQL are managed through efficient indexing strategies and storage design, utilizing advanced operators and maintenance routines to handle large data volumes while preserving data integrity.

How do I tune autovacuum and configure partitioning for growing PostgreSQL datasets?▼

Autovacuum tuning and partitioning manage growing PostgreSQL datasets by optimizing vacuum scheduling and data segmentation, ensuring lower latency and higher throughput.

Can I use this guidance for PostgreSQL replication and high availability setup?▼

PostgreSQL replication setup and connection management are supported for high availability scenarios, providing replica configuration and risk-aware recommendations to ensure resilience across production deployments of all sizes.

Does PostgreSQL connection management work for production deployments scaling out?▼

Connection management supports production PostgreSQL deployments of all sizes by addressing HA and scaling scenarios, delivering version-aware configuration analysis and actionable optimization steps for reliable database performance.

Related Skills

Explore More Software Engineering Skills→
bobmatnycbobmatnyc
20

PostgreSQL Performance Optimization

Analyze PostgreSQL 15+ queries, indexes, and configuration using EXPLAIN ANALYZE.

Community
Advanced
tutur3ututur3u
53

supabase-postgres-best-practices

Guide PostgreSQL and Supabase deployments with query optimization and indexing rules.

Official
Advanced
nhonvonhonvo

postgres-expert

Optimize PostgreSQL performance and administration for production databases.

Community
Advanced
zinohomezinohome
1

db-performance-watchlist

Monitor database performance with slow query detection and resource alerts.

Community
Advanced