Local environments are a dangerous sandbox. What runs in 10ms on a dev machine can easily lock a production table for minutes. This post is a great reminder that understanding the underlying engine—like how PostgreSQL handles NOT NULL constraints—is what prevents total outages.