postgresql-code-review

Expert PostgreSQL code review for ${selection} (or entire project if no selection). Focus on PostgreSQL-specific best practices, anti-patterns, and quality standards that are unique to PostgreSQL. Focus on PostgreSQL's unique capabilities and ensure the code leverages what makes PostgreSQL special rather than treating it as a generic SQL database. - Avoiding PostgreSQL-specific indexes : Not using GIN/GiST for appropriate data types - Misusing JSONB : Treating JSONB like a simple string field - Ignoring array operators : Using inefficient array operations - Poor partition key selection : Not leveraging PostgreSQL partitioning effectively - Not using ENUM types : Using VARCHAR for limited value sets - Ignoring constraints : Missing CHECK constraints for data validation - Wrong data types : Using VARCHAR instead of TEXT or CITEXT - Missing JSONB structure : Unstructured JSONB without validation - Data Type Optimization : Ensure PostgreSQL-specific types are used appropriately - Index Strategy : Review index types and ensure PostgreSQL-specific indexes are utilized - JSONB Structure : Validate JSONB schema design and query patterns - Function Quality : Review PL/pgSQL functions for efficiency and best practices - Extension Usage : Verify appropriate use of PostgreSQL extensions - Performance Features : Check utilization of PostgreSQL's advanced features - Security Implementation...