cheatsheets Jun 28, 2026 updated Jun 28, 2026
PostgreSQL Production Checklist
A compact checklist for Postgres-backed backend services.
- Status
- evergreen
- Visibility
- public
- Role Area
- Database design / Postgres / MongoDB
- Priority
- P0
- Confidence
- operational
- Category
- Databases
- Difficulty
- intermediate
- Published
- Jun 28, 2026
- Updated
- Jun 28, 2026
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.
Source Links
Related Notes
Runbooks Jun 28, 2026 P0 intermediate
PostgreSQL Production Notes
Operational Postgres concepts for backend engineers: schemas, indexes, transactions, migrations, and reliability.
Cheat Sheets Jun 28, 2026 P0 intermediate
Database Design Checklist
A checklist for choosing and shaping relational or document data models.
Runbooks Jun 28, 2026 P0 intermediate
Database Design Mental Models
A durable set of data modeling questions for relational and document databases.
Cheat Sheets Jun 28, 2026 P1 intermediate
MongoDB Data Modeling Checklist
A checklist for deciding when to embed, reference, index, and evolve MongoDB documents.
Cheat Sheets Jun 28, 2026 P0 intermediate
Kubernetes Operational Checklist
A small operational checklist for Kubernetes services and AI workloads.
Backlinks
Runbooks Jun 28, 2026 P0 intermediate
PostgreSQL Production Notes
Operational Postgres concepts for backend engineers: schemas, indexes, transactions, migrations, and reliability.