Re: using index to speedup add not null constraints to a table
jian he <jian.universality@gmail.com>
From: jian he <jian.universality@gmail.com>
To: Álvaro Herrera <alvherre@kurilemu.de>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-02-04T06:27:03Z
Lists: pgsql-hackers
Attachments
- v10-0001-using-indexscan-to-speedup-add-not-null-constraints.patch (text/x-patch) patch v10-0001
hi. Please check the attached v10. Turns out regress test is doable, I just need to SET client_min_messages TO DEBUG1; It is now implemented as a single static function, index_check_notnull, located in tablecmd.c. I believe I have addressed all of your other points as well. -- jian https://www.enterprisedb.com/