Apply PostgreSQL best practices for schema design, indexing, and replication.
npx skills add https://github.com/PageAI-Pro/ralph-loop --skill postgres-pageai-pro
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/PageAI-Pro/ralph-loop/tree/main/.agent/skills/postgres Command: npx skills add https://github.com/PageAI-Pro/ralph-loop --skill postgres-pageai-pro
PostgreSQL systems often struggle with performance bottlenecks, misconfiguration, and unreliable operations in production, leading to slow queries and downtime.
Identify current bottlenecks in your PostgreSQL deployment and apply the recommended settings from the guide to improve query performance and reliability.
High-intent search queries and answers about installing and using this skill.
PostgreSQL vacuuming removes dead tuples to reclaim storage and prevent transaction ID wraparound. Regular vacuuming maintains database health by reducing bloat, improving query performance, and ensuring reliable operations across your production clusters.
PostgreSQL replication creates copies of your database to ensure high availability and distribute read traffic. Configuring replication correctly validates your high-availability setups, minimizing downtime and maintaining reliable operations during failures.
PostgreSQL backup and recovery involves creating restorable copies of your database to prevent data loss. Using practical checklists and reference material ensures your deployment maintains robust restore readiness and survives incident response scenarios.
Proper PostgreSQL schema design requires satisfying rules for effective primary keys and appropriate data types. Applying these schema design best practices ensures data integrity, optimizes storage, and establishes a foundation for reliable database performance.
ariesanhthuOptimize PostgreSQL queries, indexing, JSONB, partitioning, and replication.
oalansilvaGuide process management, monitoring, and scaling decisions for production servers.
pohlai88Optimize PostgreSQL performance with indexing, partitioning, and replication strategies.
miles990Profile CPU and memory usage to identify performance bottlenecks.
