skills.rest
token-overflow
token-overflowOFFICIAL
Explore all skills by this author →
Website𝕏@tokenoverflowioGitHub

postgres

Identify PostgreSQL performance bottlenecks in live OLTP and OLAP databases.

Updated Jan 31, 2026
Search Tags:#performance#monitoring#postgresql#maintenance#tuning#postgres
One-click install
npx skills add https://github.com/token-overflow/tokenoverflow --skill postgres-token-overflow
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres
Source: https://github.com/token-overflow/tokenoverflow/tree/main/.agents/skills/postgres
Command: npx skills add https://github.com/token-overflow/tokenoverflow --skill postgres-token-overflow

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

PostgreSQL performance and reliability challenges arise from misconfigurations, unoptimized queries, and maintenance gaps across indexing, vacuuming, memory settings, and replication.

Core Features & Use Cases

  • Indexing and query optimization best practices
  • Maintenance and monitoring guidance for large or complex PostgreSQL deployments
  • Real-world scenarios: tuning a read-heavy warehouse, stabilizing write-heavy OLTP, configuring replication and backups

Quick Start

Baseline your PostgreSQL deployment and apply the recommended tuning steps to improve performance and reliability.

Frequently Asked Questions about postgres

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

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

You can identify PostgreSQL performance bottlenecks by analyzing query planning, checking autovacuum behavior, and evaluating WAL and checkpoint mechanics. This Skill provides guidelines and references to isolate issues across indexing, memory tuning, and partitioning for both OLTP and OLAP workloads.

What is the best way to tune a write-heavy OLTP PostgreSQL deployment?▼

To tune a write-heavy OLTP PostgreSQL deployment, you need to stabilize write operations by adjusting memory settings, configuring autovacuum behavior, and optimizing WAL and checkpoint mechanics. This Skill provides checklists for safely configuring these internal parameters to improve reliability.

How does autovacuum behavior affect PostgreSQL maintenance and reliability?▼

Autovacuum behavior affects PostgreSQL maintenance by reclaiming space from deleted tuples and preventing transaction ID wraparound. Properly configuring autovacuum is crucial for maintenance, and this Skill offers references to tune its behavior for large or complex deployments to ensure database reliability.

Can I use these PostgreSQL tuning guidelines for read-heavy OLAP warehouse workloads?▼

Yes, these PostgreSQL tuning guidelines apply to read-heavy OLAP warehouse workloads. The Skill covers indexing, memory tuning, and partitioning techniques specifically required to optimize complex analytical queries and improve overall data warehouse performance.

What PostgreSQL internals knowledge is required to optimize query planning and replication?▼

Optimizing query planning and replication requires knowledge of PostgreSQL internals, specifically WAL and checkpoint mechanics, and autovacuum behavior. This Skill serves as a reference for administrators to safely apply advanced tuning steps using this foundational knowledge.

Related Skills

Explore More Software Engineering Skills→
LaurentPRAT-DBLaurentPRAT-DB

performance-tuning

Analyze Databricks metrics and logs to tune Spark configuration and caching.

Community
Intermediate
JaviMontanoJaviMontano

metodologia-database-architecture

Design database architectures for OLTP, OLAP, HTAP, and mixed workloads.

Community
Advanced
manutejmanutej
61

postgresql-database-engineering

Optimize PostgreSQL queries and schemas with indexing, partitioning, replication, and VACUUM maintenance.

Community
Advanced
rajyeole6rajyeole6

agency-database-optimizer

Analyze EXPLAIN ANALYZE plans and optimize PostgreSQL indexing strategies.

Community
Advanced