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

Edit

ID 4971

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

Topic Performance

Created 2024-05-05 23:40:20

Last modified 2025-02-03 22:46:54 (1 week ago)

Latest email 2025-02-04 01:38:00 (1 week ago)

Status

2025-03: Needs review

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)

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