using index to speedup add not null constraints to a table

Edit
ID 5444
Title using index to speedup add not null constraints to a table
CI (CFBot) Summary
Stats (from CFBot) Patch version: v9, Patch count: 1, First patch: +606−6, All patches: +606−6
Tags
Created 2024-12-17 08:45:07
Last modified 2026-01-31 17:20:39 (1 hour ago)
Latest email 2026-01-31 17:20:14 (1 hour ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
Target version 18
Authors Jian He (stayreal)
Reviewers Tanzeel Khan (tanzeelk)Become reviewer
Committer Álvaro Herrera (alvherre)
Links
Emails
using index to speedup add not null constraints to a table
First at 2024-12-16 07:07:51 by jian he <jian.universality at gmail.com>
Latest at 2026-01-31 17:20:14 by Álvaro Herrera <alvherre at kurilemu.de>
Latest attachment (v9-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2026-01-16 04:22:43 from jian he <jian.universality at gmail.com>
    Attachment (v9-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2026-01-16 04:22:43 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v8-0001-using-indexscan-to-speedup-add-not-null-constrain.patch) at 2026-01-13 17:30:27 from Álvaro Herrera <alvherre at kurilemu.de> (Patch: Yes)
    Attachment (v7-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2025-10-20 06:26:24 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v6-0001-using-indexscan-to-speedup-add-not-null-constrain.patch) at 2025-05-14 09:16:14 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v5-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2025-04-28 04:36:14 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v4-0001-using-indexscan-to-speedup-add-not-null-constrain.patch) at 2025-04-18 08:07:34 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v3-0001-using-index-to-speedup-add-not-null-constraint-to.patch) at 2025-02-05 08:24:31 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v2-0001-using-index-to-speedup-add-not-null-constraint-to.patch) at 2024-12-31 16:09:42 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v1-0001-using-index-to-speedup-add-not-null-constraint-to.patch) at 2024-12-16 07:07:51 from jian he <jian.universality at gmail.com> (Patch: Yes)
History
When Who What
2026-01-31 17:20:39 Álvaro Herrera (alvherre) Moved from CF PG19-4 to CF PG19-Final
2026-01-13 18:03:27 CFbot Patch does not need rebase anymore
2025-12-03 08:57:25 Jian He (stayreal) Moved from CF PG19-3 to CF PG19-4
2025-11-25 03:27:21 CFbot Patch needs rebase
2025-10-20 06:37:24 CFbot Patch does not need rebase anymore
2025-10-16 19:56:25 Álvaro Herrera (alvherre) Added alvherre as committer
2025-10-09 16:46:20 CFbot Patch needs rebase
2025-10-09 16:05:18 Jian He (stayreal) Moved from CF PG19-1 to CF PG19-3
2025-05-06 06:27:18 Tanzeel Khan (tanzeelk) Added tanzeelk as reviewer
2025-02-27 14:13:27 Jian He (stayreal) Closed in commitfest 2025-03 with status: Moved to next CF
2025-02-09 15:19:07 Peter Eisentraut (petere) Closed in commitfest 2025-01 with status: Moved to next CF
2025-01-15 07:52:09 Jian He (stayreal) Changed targetversion to 18
2024-12-17 08:45:31 Jian He (stayreal) Changed authors to Jian He (stayreal)
2024-12-17 08:45:07 Jian He (stayreal) Attached mail thread CACJufxFiW=4k1is=F1J=r-Cx1RuByXQPUrWB331U47rSnGz+hw@mail.gmail.com
2024-12-17 08:45:07 Jian He (stayreal) Created patch record
Edit