On Wed, Sep 08, 2021 at 07:09:31AM +0200, Alexander Kukushkin wrote: > Hi, > > On Wed, 8 Sep 2021, 06:59 hubert depesz lubaczewski, <depesz@xxxxxxxxxx> > wrote: > > > Hi, > > we needed recently to add not null constraint on some fields, and it > > struck me that it took long. > > Obviously - pg has to check the data. But it seems that it can't use > > index. > > > > It can't use the index, but can use an already existing CHECK CONSTRAINT, > that could be created as NOT VALID and validated without holding heavy > locks. After adding not null you can drop the constraint. Thanks. Forgot about these. Best regards, depesz
