Request a Demo
Home   >   mailing lists

Re: using index to speedup add not null constraints to a table - Mailing list pgsql-hackers

From jian he
Subject Re: using index to speedup add not null constraints to a table
Date
Msg-id CACJufxEkSyhOotK0b3hj_D3c9HO=dxGoGxL3Cx4j6enG_t_P6Q@mail.gmail.com
Whole thread
In response to Re: using index to speedup add not null constraints to a table  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
Tree view 
Hi.
Please check the attached v16.

The condition for using indexscan to verify the column has not changed.
What changed: index_check_notnull logic simplifction, common helper
function: queue_notnull_validation
for setting up tab->constraints and tab->verify_new_notnull.

I also used the attached bench.txt to benchmark.



--
jian
https://www.enterprisedb.com/
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: injection_points: canceled or terminated waiters leak their wait slots
Next
From: Michael Paquier
Date:
Subject: Re: [PATCH] Clear FatalError earlier during crash restart