PostgreSQL Production Checklist

Schema

• Primary keys are explicit.
• Foreign keys protect important relationships.
• Constraints encode invariants.
• Timestamps use a consistent convention.

Querying

• Slow queries are measured.
• Indexes match filters, joins, and sorts.
• Pagination avoids large offsets when needed.
• N+1 query paths are checked.

Operations

• Connection pooling is configured.
• Backups are automated.
• Restore has been tested.
• Migrations avoid long locks.