The “SET NOT NULL” Downtime Trap in PostgreSQL
It’s necessary to validate existing data when trying to set a column to “not null.” The validation requires an “Access Exclusive” lock which blocks all access to the table, i.e. Continue reading The “SET NOT NULL” Downtime Trap in PostgreSQL
