Re: using index to speedup add not null constraints to a table

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: using index to speedup add not null constraints to a table
Date: 2024-12-31 16:09:42
Message-ID: CACJufxFcYL+XU-f+HP4Zi1h5tDhJ+rYSTvPui2W2bMR7p-eJ-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

In v1 I didn't do the `git add` for newly created isolation test related files.
so the cfbot for isolation tests failed.

v1 with index:
create index t_idx_ab on t(a,b);
we cannot fast add a not-null constraint for column b.
with the attached v2 patch, now we can do that.

v2, isolation test also adds other session drop index scarenio.

Attachment Content-Type Size
v2-0001-using-index-to-speedup-add-not-null-constraint-to.patch text/x-patch 33.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Sabino Mullane 2024-12-31 16:18:27 Re: add vacuum starttime columns
Previous Message Bernd Helmle 2024-12-31 16:06:35 Modern SHA2- based password hashes for pgcrypto