Postgres And Relational Data Modeling

Use When

• Relational persistence is core to the product
• Schema or query performance issues appear

Workflow

1. Model entities, constraints, and ownership boundaries
2. Plan migrations with expand-migrate-contract
3. Define indexes and query paths for hot endpoints
4. Add connection pooling and timeout policies
5. Validate backup, restore, and replication assumptions

Required Checks