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: v16, Patch count: 1, First patch: +413−10, All patches: +413−10
Tags
Created 2024-12-17 08:45:07
Last modified 2026-09-02 02:40:49 (4 weeks ago)
Latest email 2026-09-30 00:00:00 (22 hours ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
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
Authors Jian He (stayreal)
Reviewers Tanzeel Khan (tanzeelk) Become reviewer
Committer
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-09-30 00:00:00 by jian he <jian.universality at gmail.com>
Latest attachment (bench.txt) at 2026-09-30 00:00:00 from jian he <jian.universality at gmail.com>
    Attachment (bench.txt) at 2026-09-30 00:00:00 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v15-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2026-07-16 08:55:56 from jian he <jian.universality at gmail.com> (Patch: No)
    Attachment (v14-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2026-04-08 01:45:50 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v13-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2026-04-07 07:39:50 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v12-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2026-02-06 04:58:09 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2026-02-04 12:52:57 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v10-0001-using-indexscan-to-speedup-add-not-null-constraints.patch) at 2026-02-04 06:27:03 from jian he <jian.universality at gmail.com> (Patch: Yes)
    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-09-30 00:36:46 CFbot Patch does not need rebase anymore
2026-09-02 02:40:49 Jian He (stayreal) Moved from CF PG20-2 to CF PG20-3
2026-08-28 06:06:25 CFbot Patch needs rebase
2026-08-01 00:00:09 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-16 09:02:01 CFbot Patch does not need rebase anymore
2026-04-22 12:27:23 CFbot Patch needs rebase
2026-04-14 06:59:25 Jian He (stayreal) Moved from CF PG19-Final to CF PG20-1
2026-04-02 13:10:39 Álvaro Herrera (alvherre) Removed alvherre from committers
2026-02-03 18:42:18 Álvaro Herrera (alvherre) Changed targetversion to None
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