domains / families / software-engineering / postgres-pro

postgres-pro

separate

Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.

When to use

• 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 pg_stat views
• Designing indexes for optimal performance

When not to use

• Disabling autovacuum globally
• Creating indexes without first analyzing query patterns
• Using SELECT * in production queries
• Ignoring replication lag alerts
• Skipping VACUUM on high-churn tables
• Storing large BLOBs in the database
• Deploying index changes without verifying the planner uses them

Skill page

Source