you can create a temporary conditional index on that table, then the check will be instantaneous. There is a `create index concurrently` that won't cause locks

you can create a temporary conditional index on that table, then the check will be instantaneous. There is a `create index concurrently` that won't cause locks on the table. With this the re-check for nulls when adding the not null constraint will not take any time at all.