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: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-02-05T08:24:31Z

Lists: pgsql-hackers

Attachments

v3-0001-using-index-to-speedup-add-not-null-constraint-to.patch (text/x-patch) patch v3-0001

hi

rebased new patch attached.
I also did some cosmetic changes. comments refined.
make sure using index_scan mechanism to fast check column not-null can
only be used via btree index.
isolation tests are simplified.