postgresql-optimization

Expert guidance on PostgreSQL-specific features, optimization patterns, and advanced data type capabilities. Expert PostgreSQL guidance for ${selection} (or entire project if no selection). Focus on PostgreSQL-specific features, optimization patterns, and advanced capabilities. Performance Impact : Expected 80% improvement in execution time Focus on providing specific, actionable PostgreSQL optimizations that improve query performance, security, and maintainability while leveraging PostgreSQL's advanced features. - Covers JSONB operations, array types, window functions, full-text search, custom types, range types, and geometric types with practical examples - Includes query optimization strategies using EXPLAIN ANALYZE, index design patterns (composite, partial, covering, expression), and connection/memory management - Provides monitoring and maintenance techniques via pg_stat_statements, pg_stat_user_indexes, and database size analysis - Demonstrates common anti-patterns alongside optimized alternatives for pagination, aggregation, and JSON queries with expected performance improvements - Use EXPLAIN (ANALYZE, BUFFERS) for detailed query analysis - Configure postgresql.conf for your workload (OLTP vs OLAP) - Use connection pooling (pgbouncer) for high-concurrency applications - Regular VACUUM and ANALYZE for optimal performance - Partition large tables using PostgreSQL 10+...