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-04 12:52:57
Message-ID:	CACJufxFVioUh+hKcgHcUVp2GZnG-rEN1qAonp=e4wHHmVCK_JQ@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2024-12-16 07:07:51 from jian he <jian(dot)universality(at)gmail(dot)com> 📎  2024-12-31 16:09:42 from jian he <jian(dot)universality(at)gmail(dot)com> 📎   2025-02-05 08:24:31 from jian he <jian(dot)universality(at)gmail(dot)com> 📎    2025-04-18 08:07:34 from jian he <jian(dot)universality(at)gmail(dot)com> 📎     2025-04-28 04:36:14 from jian he <jian(dot)universality(at)gmail(dot)com> 📎      2025-04-28 08:40:53 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>       2025-05-14 09:16:14 from jian he <jian(dot)universality(at)gmail(dot)com> 📎        2025-10-16 19:57:44 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>         2025-10-20 06:26:24 from jian he <jian(dot)universality(at)gmail(dot)com> 📎          2026-01-13 17:30:27 from Álvaro Herrera <alvherre(at)kurilemu(dot)de> 📎           2026-01-14 09:05:35 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>            2026-01-16 04:22:43 from jian he <jian(dot)universality(at)gmail(dot)com> 📎             2026-01-31 17:20:14 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>              2026-02-04 06:27:03 from jian he <jian(dot)universality(at)gmail(dot)com> 📎               2026-02-04 12:52:57 from jian he <jian(dot)universality(at)gmail(dot)com> 📎      2025-05-13 13:37:30 from Andres Freund <andres(at)anarazel(dot)de>
Lists:	pgsql-hackers

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

In response to

• Re: using index to speedup add not null constraints to a table at 2026-02-04 06:27:03 from jian he

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Amul Sul	2026-02-04 13:09:10	Re: pg_waldump: support decoding of WAL inside tarfile
Previous Message	Viktor Holmberg	2026-02-04 12:52:10	Re: ON CONFLICT DO SELECT (take 3)