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
Database Design
SkillA PostgreSQL schema guide that names the types you should never reach for.
AlloyDB for PostgreSQL Skills
SkillDrives an AlloyDB for PostgreSQL cluster from an agent: provisioning, schema, health and replication.
Spanner Skills
SkillQueries Spanner in either the GoogleSQL or PostgreSQL dialect and lists its property graphs.
Comments(0)
Sign in to comment