Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

Edit

ID 4971

Title Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

Topic Performance

Created 2024-05-05 23:40:20

Last modified 2024-12-02 13:24:49 (1 month, 2 weeks ago)

Latest email 2025-01-08 02:12:00 (1 week, 3 days ago)

Status

2025-01: Needs review

2024-11: Moved to next CF

2024-09: Moved to next CF

2024-07: Moved to next CF

Target version

Authors Michail Nikolaev (nkey)

Reviewers Matthias van de Meent (mmeent)Become reviewer

Committer

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4971
git checkout commitfest/cf/4971

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-01-08 02:12:00 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest 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>
    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
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