postgresql-optimization

原文涵盖的主题

• PostgreSQL Optimization Workflow
• Overview
• When to Use This Workflow
• Workflow Phases
• Phase 1: Performance Assessment
• Skills to Invoke
• Actions
• Copy-Paste Prompts

Specialized workflow for PostgreSQL database optimization including query tuning, indexing strategies, performance analysis, vacuum management, and production database administration. Use this workflow when: Optimizing slow PostgreSQL queries Designing indexing strategies Analyzing database performance Tuning PostgreSQL configuration Managing production databases database-optimizer - Database optimization postgres-best-practices - PostgreSQL best practices 1. Check database version 2. Review configuration 3. Analyze slow queries 4. Check resource usage 5. Identify bottlenecks sql-optimization-patterns - SQL optimization postgres-best-practices - PostgreSQL patterns 1. Run EXPLAIN ANALYZE 2. Identify scan types 3. Check join strategies 4. Analyze execution time 5. Find optimization opportunities database-design - Index design postgresql - PostgreSQL indexing 1. Identify missing indexes 2. Create B-tree indexes 3. Add composite indexes 4. Consider partial indexes 5. Review index usage sql-optimization-patterns - Query tuning sql-pro - SQL expertise 1. Rewrite inefficient queries 2. Optimize joins 3. Add CTEs where helpful 4. Implement pagination 5. Test improvements postgres-best-pra

这里只展示节选，请以完整原文和当前要求为准。