0. Constraints and Indexes
Enforce data integrity and improve query performance with PostgreSQL constraints and indexes.
Primary and Foreign Keys
Model relational integrity in PostgreSQL with primary keys, foreign keys, and performance-aware referential design (including indexing FKs). Focus: Primary and Foreign Keys.
Column and Table Constraints
Enforce PostgreSQL data quality with NOT NULL, UNIQUE, CHECK, and DEFAULT constraints, plus safe rollout patterns for large tables. Focus: Column and Table Constraints.
Index Strategy and Maintenance
Design PostgreSQL indexes for real query patterns (B-tree, GIN, BRIN, partial/expression/covering) and maintain them with evidence using EXPLAIN (ANALYZE). Focus: Index Strategy and Maintenance.