postgresql

PostgreSQL Database

Performance & Design

• MUST use connection pooling for efficient connection management
• MUST use JSONB columns for semi-structured data (avoid creating many tables for flexible schemas)
• MUST create indexes on frequently queried columns to improve read performance

Query Optimization

• SHOULD monitor query plans for expensive operations
• SHOULD use partial indexes when filtering on specific conditions
• SHOULD consider materialized views for complex aggregations