Schema design
Best practices for designing efficient PostgreSQL schemas and managing database objects.
Guides by Category
DDL Operations
Safely perform schema changes with minimal downtime.
- How to redefine a PK without downtime - 6 min (intermediate)
- How to drop a column - 5 min (advanced)
- How to add a column - 5 min (advanced)
- How to add a CHECK constraint without downtime - 5 min (intermediate)
Data Types
Choose the right data types and understand their performance implications.
- How to use UUID - 5 min (intermediate)
- UUID v7 and partitioning (TimescaleDB) - 5 min (advanced)
- How to quickly check data type and storage size of a value - 5 min (intermediate)
Constraints
Implement and manage database constraints effectively.