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.