PostgreSQL Optimization
PostgreSQL-specific query, index and data-type guidance for a schema you already have.
Install
gh skills install github/awesome-copilot postgresql-optimization
PostgreSQL şeması ya da sorgusu gözden geçirilirken, sorgu yavaşladığında veya JSONB, dizi, aralık gibi Postgres'e özgü tipler tasarlanırken
- Author
- Shubham Gaikwad
- License
- MIT
Leans on the parts of Postgres a generic SQL assistant tends to ignore: JSONB containment queries behind a GIN index, array operators, range and geometric types, custom domains, full-text search and window functions. The performance half runs on EXPLAIN (ANALYZE, BUFFERS) for individual queries and pg_stat_statements for finding which ones matter, alongside index strategy, partial indexes, connection and memory settings, and routine VACUUM and ANALYZE. Closes with a checklist and worked patterns for pagination, aggregation and JSON access.
Similar skills
Ponytail
SkillArgues for the smallest change that actually solves the problem.
pysam
SkillReads and writes BAM, CRAM and VCF files from Python through HTSlib.
AWS Core Skills
SkillTwenty AWS-published skills covering CDK, IAM, containers, observability and cost.
Comments(0)
Sign in to comment