The Postgres migration that locks your table at 3am, and how to catch it in review

-- looks fine in review, locks your busiest table in prod: ALTER TABLE users ALTER COLUMN email SET NOT NULL; -- same result, no outage: ALTER TABLE users ADD CONSTRAINT users_email_nn CHECK (email IS...