postgres-expert

Optimize PostgreSQL queries, JSONB indexes, and partitioning strategies.

218|14|Updated Apr 5, 2025

Search Tags:#indexing #postgresql #partitioning #query-optimization #jsonb #database-performance #autovacuum

Ready to run

npx skills add https://github.com/cin12211/orca-q --skill postgres-expert

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/cin12211/orca-q/tree/main/.agent/skills/postgres-expert
Command: npx skills add https://github.com/cin12211/orca-q --skill postgres-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides expert-level PostgreSQL optimization, indexing, and administration capabilities to maximize performance and reliability.

Core Features & Use Cases

Query optimization: Identify and optimize slow queries, tune planner settings, and build effective indexes.
JSONB optimization: Create and manage JSONB indexes, optimize JSONPath queries, and implement efficient data access patterns.
Partitioning and maintenance: Implement time-based partitioning, manage autovacuum tuning, and maintain large datasets efficiently.
Use Case: A production PostgreSQL cluster with heavy analytic workloads requiring fast query times and robust data governance.

Quick Start

Run targeted PostgreSQL diagnostics, then apply indexing and partitioning recommendations across the database to improve performance.

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 in a production environment?▼

To optimize slow PostgreSQL queries, you can run systematic diagnostics to identify bottlenecks, tune planner settings, and build effective indexes. This approach targets complex queries to maximize performance and reliability across production workloads.

What is the best way to create indexes for JSONB data in PostgreSQL?▼

Creating JSONB indexes in PostgreSQL involves managing JSONPath queries and implementing efficient data access patterns. This skill provides strategies to create and optimize JSONB indexes for handling complex JSON data structures effectively.

When do I need time-based partitioning for large PostgreSQL datasets?▼

Time-based partitioning for large PostgreSQL datasets is needed when managing heavy analytic workloads and ensuring robust data governance. It helps maintain large datasets efficiently and improves query performance across production database clusters.

How does autovacuum tuning improve database performance in PostgreSQL?▼

Autovacuum tuning improves PostgreSQL database performance by systematically managing maintenance tasks on large datasets. Properly configured autovacuum settings ensure reliable operation and optimal performance in production environments with heavy workloads.

Can I use this for PostgreSQL replication and maintenance tasks?▼

Yes, this covers PostgreSQL replication and maintenance tasks as part of its systematic problem-solving workflows. It targets database administrators managing production PostgreSQL clusters, ensuring robust data governance and reliable operation.

What PostgreSQL extensions should I use for query optimization?▼

For PostgreSQL query optimization, environment detection and configuration tuning include evaluating extension usage to maximize performance. This skill guides you through systematic workflows to identify and apply the right extensions for your specific workload needs.