Optimizes PostgreSQL configuration, queries, replication, and observability for reliable performance.
npx skills add https://github.com/oren-argu/papermark --skill postgres-oren-argu
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/oren-argu/papermark/tree/main/.agents/skills/postgres Command: npx skills add https://github.com/oren-argu/papermark --skill postgres-oren-argu
PostgreSQL deployments often suffer from inconsistent performance, maintenance overhead, and fragile configurations. This Skill consolidates proven PostgreSQL practices—covering schema design, optimization, replication, and operational tuning—into a single, actionable guide to improve reliability and efficiency.
Review the PostgreSQL best practices and apply the recommended settings to your database deployment.
High-intent search queries and answers about installing and using this skill.
PostgreSQL optimization involves establishing recommended memory, WAL, and checkpoint settings to ensure stable operation. Applying these baseline configurations helps deployments handle varied workloads reliably without performance degradation.
PostgreSQL query tuning best practices focus on optimizing queries, implementing effective indexing strategies, and configuring vacuum and autovacuum settings. These steps ensure durable performance and efficient data retrieval.
PostgreSQL high-availability patterns require configuring robust replication and failover readiness. Outlining these patterns ensures production deployments maintain uptime and data redundancy during failures.
PostgreSQL inconsistent performance and maintenance overhead typically stem from fragile configurations and unoptimized maintenance tasks. Applying proven operational tuning and vacuum settings resolves these reliability issues.
Yes, PostgreSQL production issues can be diagnosed and resolved using actionable procedures from this Skill. It provides operational best practices to troubleshoot and fix common database problems efficiently.
PostgreSQL connection management and monitoring require robust patterns for observability. Establishing these practices ensures database health is trackable and connections are handled efficiently in production.
fromej-devA P2P lending platform where users can borrow and lend directly, without intermediaries. It leverages blockchain smart contracts and optionally integrates with decentralized storage and AI-powered credit scoring for automated, trustless loan management and disbursement, plus optional yield generation for lenders. It also includes a gamified onboarding experiencebaht featuring cute NFTsbfs, which u
manutejOptimize PostgreSQL queries and schemas with indexing, partitioning, replication, and VACUUM maintenance.
arbazkhan971Optimize PostgreSQL production performance with tuning, indexing, and replication guidance.
rnavarychCompare 12 NewSQL and distributed SQL databases for consistency and sharding.
