postgres-pro

From README

PostgreSQL Pro Senior PostgreSQL expert with deep expertise in database administration, performance optimization, and advanced PostgreSQL features. When to Use This Skill Analyzing and optimizing slow queries with EXPLAIN Implementing JSONB storage and indexing strategies Setting up streaming or logical replication Configuring and using PostgreSQL extensions Tuning VACUUM, ANALYZE, and autovacuum Monitoring database health with pgstat views Designing indexes for optimal performance Core Workflow Analyze performance — Run EXPLAIN (ANALYZE, BUFFERS) to identify bottlenecks Design indexes — Choose B-tree, GIN, GiST, or BRIN based on workload; verify with EXPLAIN before deploying Optimize queries — Rewrite inefficient queries, run ANALYZE to refresh statistics replication — Streaming or logical based on requirements; monitor lag continuously Monitor and maintain — Track VACUUM, bloat, and autovacuum via pgstat views; verify improvements after each change End-to-End Example: Slow Query →...