postgres

Audit PostgreSQL configuration and apply tuning, monitoring, and maintenance practices.

Updated Oct 12, 2024

Search Tags:#performance #monitoring #database #tuning #postgres #vacuum

Ready to run

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

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

PostgreSQL environments often suffer from suboptimal performance and maintenance challenges that degrade reliability. This Skill consolidates best practices, tuning guidance, and troubleshooting strategies to build robust Postgres deployments.

Core Features & Use Cases

Best-practice schema design and data types to improve query performance and storage efficiency.
Comprehensive tuning, monitoring, and maintenance workflows for high-availability Postgres setups (including replication, WAL, and autovacuum).
Real-world scenarios: scaling writes with PgBouncer, preventing bloat, and ensuring robust backups and recovery readiness.

Quick Start

Audit your current PostgreSQL configuration and apply the recommended tuning, monitoring, and maintenance practices to start improving 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 tune PostgreSQL autovacuum to prevent bloat and downtime?▼

Tune PostgreSQL autovacuum by adjusting settings to prevent bloat and minimize downtime. Consolidated best practices provide configuration guidance for autovacuum thresholds, ensuring proactive health checks and safety-minded defaults for production-grade environments.

What are the best practices for PostgreSQL schema design and indexing?▼

PostgreSQL schema design best practices improve query performance and storage efficiency through optimal data types and indexing strategies. Consolidated guidance helps build robust deployments by addressing schema structure and indexing for high-availability setups.

How do I configure PgBouncer for connection management in PostgreSQL?▼

Configure PgBouncer for PostgreSQL connection management to scale writes effectively. Operational playbooks provide guidance on pooling strategies, ensuring robust connection handling and reducing overhead in production-grade Postgres environments.

What monitoring and maintenance workflows do I need for high-availability PostgreSQL?▼

High-availability PostgreSQL requires comprehensive monitoring and maintenance workflows covering WAL, replication strategies, and proactive health checks. Durable maintenance workflows ensure robust backups, recovery readiness, and reduced outages.

Why does PostgreSQL performance degrade over time and how can I fix it?▼

PostgreSQL performance degrades over time due to suboptimal configurations, bloat, and maintenance challenges. Fix it by applying consolidated tuning guidance, troubleshooting strategies, and safety-minded operational defaults to improve reliability.