using index to speedup add not null constraints to a table

5444

Title

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 (2 months ago)

Latest email

2026-09-30 00:00:00 (1 month 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) Log in to 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