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
Topic Server Features
Tags
Created 2024-12-17 08:45:07
Last modified 2025-12-03 08:57:25 (1 month ago)
Latest email 2026-01-16 04:22:43 (2 days ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
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-16 04:22:43 by jian he <jian.universality at gmail.com>
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-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