Advanced PostgreSQL: Partitioning and Schema Evolution

Implement declarative table partitioning in PostgreSQL with automatic partition routing

Analyze the stages of the expand-contract pattern, detailing the state of application code and database schema at each step to ensure zero-downtime deployment

Implement a zero-downtime column addition using the expand-contract pattern

Design a shadow table migration strategy for a complex schema change, outlining the trigger logic, backfill process, and cutover plan

Implement triggers to dually write to an original table and a shadow table during a migration

Execute and monitor a data backfill process to populate a shadow table without locking the original table

Perform an atomic cutover to a shadow table using a table rename and validate the migration's success