Schema migrations without downtime
A migration runs against a live application. Expand, migrate, contract lets you change a schema while both old and new code are running.
- 32m
- Intermediate
Video by PostgresTV · YouTube
Check your understanding
3 questions. Unlocks when you finish the video.
Overview
What this lesson covers
- Apply the expand, migrate, contract pattern
- Avoid locks that block writes on large tables
- Make every migration reversible or forward-only on purpose
This lesson sits in Operating Postgres, part of PostgreSQL for Developers. It assumes what came before it and leads directly into the next lesson in the module.
In this lesson you will:
- Apply the expand, migrate, contract pattern
- Avoid locks that block writes on large tables
- Make every migration reversible or forward-only on purpose
Resources
Your notes will live here
Note taking is not available yet. Nothing you type would be saved, so the tab stays read-only for now.