postgresql-optimization

Apply PostgreSQL optimization techniques to database design, indexing, and queries.

Updated Oct 12, 2024

Search Tags:#performance #indexing #postgresql #sql #query-optimization #extensions

Ready to run

npx skills add https://github.com/samrocks03/shuttle-office-service --skill postgresql-optimization-samrocks03

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgresql-optimization
Source: https://github.com/samrocks03/shuttle-office-service/tree/main/.agents/skills/postgresql-optimization
Command: npx skills add https://github.com/samrocks03/shuttle-office-service --skill postgresql-optimization-samrocks03

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Leverages PostgreSQL-specific features, data types, and extensions to help teams design, optimize, and maintain high-performance PostgreSQL databases.

Core Features & Use Cases

Comprehensive guidance on JSONB operations, array types, custom types, range and geometric types, full-text search, window functions, and extensions.
Practical patterns for query optimization, indexing strategies, and performance tuning across OLTP/OLAP workloads.
Real-world scenarios and best practices for schema design, tooling, and verification of performance improvements.

Quick Start

Apply PostgreSQL performance best practices to a representative schema and optimize a sample query to illustrate improvements.

Frequently Asked Questions about postgresql-optimization

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

FAQPage Schema

How do I optimize PostgreSQL query performance for slow OLTP workloads?▼

To optimize PostgreSQL query performance for slow OLTP workloads, apply specific indexing strategies and query optimization patterns to reduce execution latency. This approach provides concrete best practices to validate and maintain high-speed transactional database operations.

What is the best way to use JSONB operations and array types in PostgreSQL?▼

The best way to use JSONB operations and array types in PostgreSQL is leveraging native data type features to structure schema design efficiently. This method delivers practical patterns for handling complex data while maintaining high-performance database queries.

Does this PostgreSQL optimization approach support both OLTP and OLAP workloads?▼

Yes, this PostgreSQL optimization approach supports both OLTP and OLAP workloads by providing targeted performance tuning patterns. It applies comprehensive query optimization and indexing strategies across distinct transactional and analytical processing contexts.

How do I implement full-text search and window functions in PostgreSQL?▼

To implement full-text search and window functions in PostgreSQL, apply the advanced feature guidance to execute complex analytical queries. This process provides code examples and best practices to build high-performance data retrieval operations.

When should I use PostgreSQL extensions for database performance tuning?▼

You should use PostgreSQL extensions for database performance tuning when native indexing strategies cannot resolve specific query bottlenecks. This approach supplies real-world scenarios to verify when extension usage delivers measurable performance improvements.