postgres-performance
CommunityBoost PostgreSQL performance with proven patterns
Software Engineering#performance#caching#indexing#postgresql#partitioning#query-optimization#connection-pooling
AuthorCJHarmath
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses PostgreSQL performance bottlenecks by providing patterns to optimize queries and data access.
Core Features & Use Cases
- Query Optimization Workflow
- Covering Indexes (Index-Only Scans)
- Pagination at Scale
- Batch Processing
- Efficient Aggregations
- Connection Pool Tuning
- Read Replicas
- Denormalization for Read Performance
- Partitioning Large Tables
- Caching Strategy
- Performance Monitoring Queries
Quick Start
Begin by running an initial audit with pg_stat_statements and EXPLAIN ANALYZE to identify slow queries, then implement covering indexes and consider partitioning for large datasets, followed by enabling a caching layer and tuning the connection pool.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgres-performance Download link: https://github.com/CJHarmath/claude-agents-skills/archive/main.zip#postgres-performance Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.