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

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: using index to speedup add not null constraints to a table
Date: 2026-02-06 04:58:09
Message-ID: CACJufxEh-oZ4hP_aEDfqq4NKPQjX-xVO7=Rp9+=B8eWnsFMJFA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Feb 4, 2026 at 8:52 PM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
>
> hi.
>
> v11 is attached.
> Mainly fixes regress test failures.

I have tested locally on https://cirrus-ci.com/build/5064590561640448
this time, the attachment should have no regress test failure.

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

Attachment Content-Type Size
v12-0001-using-indexscan-to-speedup-add-not-null-constraints.patch text/x-patch 21.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2026-02-06 05:11:50 Re: [PING] fallocate() causes btrfs to never compress postgresql files
Previous Message Corey Huinker 2026-02-06 04:50:20 Re: Add expressions to pg_restore_extended_stats()