Advanced Postgres Schema Design (For Scalable Application Development) bySehrope Sarkuni
summary
Postgres-specific features replace clever app hacks with concrete guarantees: using the native uuid type shrinks indexes and prevents bad IDs, a date-range column plus an exclusion constraint solves double-booking (hotel rooms) without application locks, and immutable functions like array_sort/array_unique enforce one-dimensional, ordered arrays via check constraints. The talk shows migration patterns that use transactional DDL and database templates for fast local rollback, plus expression indexes and partial indexes to make big tables fast; the examples are implemented and shown to work.
AI-written summary · about
chapters (12)
- 0:00Introduction to schema design
- 4:33Priorities in schema design
- 6:00Data types and sizing
- 10:31Row and column alignment
- 15:07Check constraints
- 18:48Advanced array usage
- 23:30Migrations and forward flow
- 29:13Minimizing locking impact
- 33:11Indexing strategies
- 37:25Views and functions
- 39:57Range types for complex data
- 44:44Q&A session
related talks
11mThe Seven Principles for Making a PostgreSQL DB Work Fast
29mPostgres Demystified
41mApplication Development Challenges with Postgres
37mPostgres at Any Scale
30mPuny to Powerful PostgreSQL Rails Apps
46mUse PostgreSQL to Step Up Your Game
24mPostgreSQL Design Patterns
49mSELECT 'amazing features' FROM "postgresql"