pg-optimization
CommunitySpeed up PostgreSQL queries for Django apps.
Software Engineering#indexing#postgresql#optimization#django#pg_stat_statements#materialized-views#explain-analyze
Authorarsen-ask-lx
Version1.0.0
Installs0
System Documentation
What problem does it solve?
PostgreSQL optimization patterns and pragmatic guidance to boost Django 5.2 applications, improving query performance, reducing latency, and simplifying maintenance across common workloads.
Core Features & Use Cases
- Index Strategies: partial, covering, GIN, GiST, and trigram indexes to optimize diverse query patterns.
- Explain Analyze Workflow: structured approach to running EXPLAIN ANALYZE, interpreting plans, and verifying improvements with pg_stat_statements.
- Connection Pooling: recommendations for native Django pooling (psycopg3) and PgBouncer in transaction mode to manage DB connections efficiently.
- Materialized Views & Patterns: guidance on using REFRESH CONCURRENTLY and modeling materialized views for analytics workloads.
Quick Start
Follow the guide to implement targeted indexing, explain analyze-driven tuning, and enable pooling in your Django-PostgreSQL stack to reduce latency.
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: pg-optimization Download link: https://github.com/arsen-ask-lx/.claude_file_4all/archive/main.zip#pg-optimization 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 471,000+ vetted skills library on demand.