skills.rest
samrocks03
samrocks03COMMUNITY
Explore all skills by this author →
GitHub

postgres

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

Updated Oct 12, 2024
Search Tags:#performance#monitoring#database#tuning#postgres#vacuum
One-click install
npx skills add https://github.com/samrocks03/shuttle-office-service --skill postgres-samrocks03
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
DexploarerDexploarer
6

database-query-optimizer

Analyze EXPLAIN plans and recommend indexes for PostgreSQL, MySQL, and MongoDB.

Community
Advanced
PatkikPatkik

docker-compose-production

Automate production-grade Docker Compose deployments with security hardening and health checks.

Community
Advanced
cenjiecenjie

postgres

Diagnose and optimize PostgreSQL databases with SQL audit queries and configuration recommendations.

Community
Advanced
interflownexinterflownex
2

alloydb-omni-optimize

Audit PostgreSQL and AlloyDB Omni configurations and manage extensions for analytical workloads.

Community
Intermediate