Tune PostgreSQL production clusters with WAL, indexing, and autovacuum best practices.
npx skills add https://github.com/cill-i-am/task-tracker --skill postgres-cill-i-am
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/cill-i-am/task-tracker/tree/main/.agents/skills/postgres Command: npx skills add https://github.com/cill-i-am/task-tracker --skill postgres-cill-i-am
PostgreSQL performance and reliability often suffer from misconfigurations, missing indexes, and inefficient maintenance. This skill provides evidence-based practices for tuning queries, managing connections, configuring WAL, and optimizing schema and storage.
Implement a starter PostgreSQL tuning plan by reviewing your current settings and applying the recommended changes in small, safe steps.
High-intent search queries and answers about installing and using this skill.
Optimize PostgreSQL performance by reviewing current settings and applying recommended changes in small, safe steps. This includes tuning memory, WAL configurations, and indexing standards to improve query speed and reliability.
Configure autovacuum and WAL settings by applying evidence-based tuning parameters. Proper configuration prevents database bloat and ensures reliable replication and failover readiness.
Troubleshoot slow PostgreSQL queries by applying optimization strategies and indexing best practices. Manage connection pooling by following concrete connection management requirements to prevent bottlenecks.
Yes, this approach is applicable to production database tuning, migration planning, incident response, and ongoing optimization. It provides technical requirements for database engineers working on production Postgres clusters.
PostgreSQL performance suffers from misconfigurations, missing indexes, and inefficient maintenance. Optimize schema and storage when experiencing slow queries, connection issues, or preparing for production database tuning.
Manual PostgreSQL tuning lacks evidence-based consistency for WAL, memory, and replication settings. Without codified best practices, production clusters risk misconfigurations and inefficient maintenance.
PsychQuantQuery official PostgreSQL documentation for SQL syntax and configuration parameters.
nhonvoOptimize PostgreSQL performance and administration for production databases.
djankiesConfigure Prisma Client connection pools for PostgreSQL deployments.
gemini-cli-extensionsRetrieve Cloud SQL for PostgreSQL instance state, extensions, and configuration parameters.
