[CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots

Edit

4971

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v20, Patch count: 12, First patch: +285−88, All patches: +3953−929

Topic

Performance

Created

2024-05-05 23:40:20

Last modified

2025-05-04 13:45:51 (3 weeks ago)

Latest email

2025-05-23 21:59:00 (1 week ago)

Status

2025-07: Needs review

2025-03: Moved to next CF

2025-01: Moved to next CF

2024-11: Moved to next CF

2024-09: Moved to next CF

2024-07: Moved to next CF

Target version

Authors

Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)

Reviewers

Matthias van de Meent (mmeent)Become reviewer

Committer

Links

Emails

Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements: First at 2023-12-15 19:07:29 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest at 2025-05-23 21:59:00 by Mihail Nikalayeu <mihailnikalayeu at gmail.com>
Latest attachment (v20-only-part-3-0002-Use-auxiliary-indexes-for-concurrent.patch_) at 2025-05-23 21:59:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com>
    Attachment (v20-only-part-3-0002-Use-auxiliary-indexes-for-concurrent.patch_) at 2025-05-23 21:59:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v19-0009-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch) at 2025-05-18 15:09:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (bench.png) at 2025-04-30 20:01:24 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: No)
    Attachment (v17-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch) at 2025-04-06 23:45:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v16-0009-Concurrently-built-index-validation-uses-fresh-s.patch) at 2025-03-07 22:58:51 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v15-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch) at 2025-02-20 14:56:20 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v14-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch) at 2025-02-04 01:38:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Add-stress-tests-for-concurrent-index-operations.patch) at 2025-01-30 01:00:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v12-0005-Allow-snapshot-resets-during-parallel-concurrent.patch) at 2025-01-18 14:18:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v11-0008-Concurrently-built-index-validation-uses-fresh-s.patch) at 2025-01-08 02:12:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (PG benchmark 2 - summary.pdf) at 2025-01-06 13:36:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)
    Attachment (image (1).png) at 2025-01-01 17:53:24 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: No)
    Attachment (v10-0010-Add-proper-handling-of-auxiliary-indexes-during-.patch) at 2025-01-01 16:16:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v9-0005-Allow-snapshot-resets-in-concurrent-unique-index-.patch) at 2024-12-24 19:39:23 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v8-0004-Allow-snapshot-resets-during-parallel-concurrent-.patch) at 2024-12-24 13:06:26 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v7-0001-this-is-https-commitfest.postgresql.org-50-5160-m.patch) at 2024-12-21 18:00:01 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v6-0005-Allow-snapshot-resets-during-parallel-concurrent-.patch) at 2024-12-17 23:29:13 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v5-0005-Allow-snapshot-resets-in-concurrent-unique-index-.patch) at 2024-12-09 20:53:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v2-0004-Allow-snapshot-resets-during-parallel-concurrent-.patch) at 2024-12-02 01:39:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Allow-advancing-xmin-during-non-unique-non-parall.patch) at 2024-11-12 15:00:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (create_index_concurrently_with_aux_index_or_rotated_snapshots.patch) at 2024-09-08 15:18:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v4-0001-WIP-fix-d9d076222f5b-VACUUM-ignore-indexing-opera.patch) at 2024-05-09 13:00:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v3-0001-WIP-fix-d9d076222f5b-VACUUM-ignore-indexing-opera.patch) at 2024-05-07 20:23:23 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v2-0001-WIP-fix-d9d076222f5b-VACUUM-ignore-indexing-opera.patch) at 2024-05-07 12:35:13 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v1-0001-WIP-fix-d9d076222f5b-VACUUM-ignore-indexing-opera.patch) at 2024-05-05 23:37:20 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)

History

When	Who	What
2025-05-23 22:31:45	CFbot	Patch does not need rebase anymore
2025-05-21 21:55:35	CFbot	Patch needs rebase
2025-05-18 15:31:53	CFbot	Patch does not need rebase anymore
2025-05-13 23:14:37	CFbot	Patch needs rebase
2025-05-04 13:45:51	Mihail Nikalayeu (mihailnikalayeu)	Changed authors to Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
2025-04-30 20:34:47	CFbot	Patch does not need rebase anymore
2025-04-21 15:19:39	CFbot	Patch needs rebase
2025-04-20 19:46:11	Mihail Nikalayeu (mihailnikalayeu)	Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-07 23:02:00	CFbot	Patch does not need rebase anymore
2025-03-03 23:32:34	CFbot	Patch needs rebase
2025-02-20 15:01:48	CFbot	Patch does not need rebase anymore
2025-02-17 09:00:36	CFbot	Patch needs rebase
2025-02-03 22:46:54	Michail Nikolaev (nkey)	Changed name to [CREATE\|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots
2025-02-03 16:59:51	Michail Nikolaev (nkey)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-02 13:24:49	Dmitry Dolgov (erthalion)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 14:09:04	Álvaro Herrera (alvherre)	Closed in commitfest 2024-09 with status: Moved to next CF
2024-10-07 14:08:56	Álvaro Herrera (alvherre)	Changed targetversion to None
2024-08-06 23:41:13	Matthias van de Meent (mmeent)	Added mmeent as reviewer
2024-08-01 02:05:13	Corey Huinker (coreyh)	Closed in commitfest 2024-07 with status: Moved to next CF
2024-05-12 10:38:40	Peter Eisentraut (petere)	Changed authors to Michail Nikolaev (nkey)
2024-05-05 23:40:35	Michail Nikolaev (nkey)	Changed targetversion to 17
2024-05-05 23:40:20	Michail Nikolaev (nkey)	Attached mail thread CANtu0oiLc-+7h9zfzOVy2cv2UuYk_5MUReVLnVbOay6OgD_KGg@mail.gmail.com
2024-05-05 23:40:20	Michail Nikolaev (nkey)	Created patch record

Edit