[CREATE|RE] INDEX CONCURRENTLY with single heap scan

Edit
ID 4971
Title [CREATE|RE] INDEX CONCURRENTLY with single heap scan
CI (CFBot) Summary
Stats (from CFBot) Patch version: v26, Patch count: 8, First patch: +245−88, All patches: +3091−569
Topic Performance
Tags Performance
Created 2024-05-05 23:40:20
Last modified 2025-11-09 21:26:20 (1 week ago)
Latest email 2025-11-09 18:02:00 (1 week ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
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
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
Target version 19
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-11-09 18:02:00 by Mihail Nikalayeu <mihailnikalayeu at gmail.com>
Latest attachment (v26-0005-Use-auxiliary-indexes-for-concurrent-index-opera.patch) at 2025-11-09 18:02:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com>
    Attachment (v26-0005-Use-auxiliary-indexes-for-concurrent-index-opera.patch) at 2025-11-09 18:02:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v25-0007-Add-Datum-storage-support-to-tuplestore.patch) at 2025-10-28 18:37:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (nocfbot-v24-only-part-3-0005-Optimize-auxiliary-index-handling.patch) at 2025-09-28 09:26:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v23-0009-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch) at 2025-09-05 00:25:56 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v22-0010-Optimize-auxiliary-index-handling.patch) at 2025-07-03 00:23:09 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v21-0012-Remove-PROC_IN_SAFE_IC-optimization.patch) at 2025-06-21 20:32:44 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    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)

Annotations

When Who Mail Annotation
2025-08-04 21:56:48 Mihail Nikalayeu (mihailnikalayeu) From Mihail Nikalayeu <mihailnikalayeu@gmail.com>
at 2025-04-30 20:01:24		 Actual patch structure
2025-08-04 21:57:59 Mihail Nikalayeu (mihailnikalayeu) From Mihail Nikalayeu <mihailnikalayeu@gmail.com>
at 2025-05-18 15:09:00		 PGConf.dev 2025 Poster
2025-11-09 21:26:20 Mihail Nikalayeu (mihailnikalayeu) From Mihail Nikalayeu <mihailnikalayeu@gmail.com>
at 2025-11-09 18:02:00		 Updated patch structure
History
When Who What
2025-11-09 21:26:20 Mihail Nikalayeu (mihailnikalayeu) Added annotation "Updated patch structure" to CADzfLwVaV15R2rUNZmKqLKweiN3SnUBg=6_qGE_ERb7cdQUD8g@mail.gmail.com
2025-11-09 21:24:56 Mihail Nikalayeu (mihailnikalayeu) Changed name to [CREATE|RE] INDEX CONCURRENTLY with single heap scan
2025-11-09 18:37:29 CFbot Patch does not need rebase anymore
2025-11-01 20:27:29 CFbot Patch needs rebase
2025-09-28 09:45:36 CFbot Patch does not need rebase anymore
2025-09-26 13:01:26 CFbot Patch needs rebase
2025-09-04 14:19:02 Mihail Nikalayeu (mihailnikalayeu) Moved from CF PG19-1 to CF PG19-3
2025-09-04 14:18:56 Mihail Nikalayeu (mihailnikalayeu) Changed targetversion to 19
2025-08-04 21:57:59 Mihail Nikalayeu (mihailnikalayeu) Added annotation "PGConf.dev 2025 Poster" to CADzfLwW9QczZW-E=McxcjUv0e5VMDctQNETbgao0K-SimVhFPA@mail.gmail.com
2025-08-04 21:56:48 Mihail Nikalayeu (mihailnikalayeu) Added annotation "Actual patch structure" to CADzfLwVOcZ9mg8gOG+KXWurt=MHRcqNv3XSECYoXyM3ENrxyfQ@mail.gmail.com
2025-07-03 00:36:33 CFbot Patch does not need rebase anymore
2025-06-27 21:46:39 CFbot Patch needs rebase
2025-06-23 08:49:59 Mihail Nikalayeu (mihailnikalayeu) Changed tags to Performance
2025-06-21 21:08:44 CFbot Patch does not need rebase anymore
2025-06-18 11:12:43 CFbot Patch needs rebase
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