LESSON 4.2

Schema migrations without downtime

31:33·5,747 learners
Daniel OkaforDaniel Okafor
Next lesson

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

A migration runs against a live application. Expand, migrate, contract lets you change a schema while both old and new code are running.

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.

UP NEXT

4.3 · Backups and connection pooling

31:12

PostgreSQL for Developers

83%

Every lesson, searchable to the second.

© 2026 BIBLION

PRIVACY · TERMS · CONTACT