Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

From:	Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To:	Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Cc:	Antonin Houska <ah(at)cybertec(dot)at>, Hannu Krosing <hannuk(at)google(dot)com>, Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>, Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Andrey Borodin <amborodin86(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>
Subject:	Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
Date:	2026-03-23 22:08:00
Message-ID:	CADzfLwVeQikArGV885zRMiSDW2-y=h=bvQiROvdq1Re1ojx9QA@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2023-12-15 19:07:29 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>  2023-12-15 21:11:59 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>   2023-12-17 20:14:27 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>    2023-12-17 23:53:34 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>     2023-12-20 09:56:33 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>      2023-12-20 11:14:32 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>       2023-12-20 16:18:18 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>        2023-12-20 16:53:27 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>         2023-12-21 13:14:19 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>          2023-12-25 14:12:41 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>           2024-01-04 11:24:04 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>            2024-01-04 12:45:06 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>             2024-01-09 17:00:28 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>              2024-02-01 16:06:28 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>               2024-02-17 21:48:44 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                2024-02-20 23:33:26 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                 2024-02-21 08:35:40 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                  2024-02-21 11:19:29 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                   2024-02-21 11:36:48 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                    2024-03-05 20:08:08 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                     2024-03-07 18:36:53 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                      2024-03-12 11:50:24 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                       2024-05-04 15:51:20 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                        2024-05-05 23:37:20 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                         2024-05-07 12:35:13 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                          2024-05-07 20:23:23 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                           2024-05-09 13:00:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                            2024-06-11 08:58:05 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                             2024-08-06 23:40:51 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                              2024-08-08 13:53:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                               2024-09-01 21:19:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                                2024-09-08 15:18:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                 2024-11-12 15:00:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                  2024-12-02 01:39:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                   2024-12-09 20:53:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                    2024-12-17 23:29:13 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                     2024-12-21 18:00:01 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                      2024-12-24 13:06:26 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                       2024-12-24 19:39:23 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                       2024-12-25 05:19:21 from Michael Paquier <michael(at)paquier(dot)xyz>                                        2024-12-25 15:14:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>                                         2025-01-01 16:16:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                          2025-01-01 17:53:24 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                          2025-01-04 01:12:58 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                           2025-01-06 13:36:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                            2025-01-08 02:12:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                             2025-01-18 14:18:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                              2025-01-30 01:00:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                               2025-02-04 01:38:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                                2025-02-20 14:56:20 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                 2025-03-07 22:58:51 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                                                  2025-04-06 23:45:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                   2025-04-30 20:01:24 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                    2025-05-18 15:09:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                     2025-05-18 15:56:54 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                                                      2025-05-18 16:09:29 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                       2025-05-23 21:59:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                        2025-06-16 16:17:33 from Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>                                                         2025-06-16 20:00:59 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                          2025-06-16 20:21:47 from Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>                                                           2025-06-17 15:55:54 from Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>                                                            2025-06-18 10:49:51 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                             2025-06-18 16:33:07 from Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>                                                              2025-06-18 21:15:28 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                               2025-06-18 21:36:43 from Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>                                                                2025-06-21 20:32:44 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                 2025-07-03 00:23:09 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                  2025-07-07 12:00:37 from Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>                                                                   2025-07-10 14:30:15 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                    2025-09-05 00:25:56 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                     2025-09-28 09:26:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                      2025-10-28 18:37:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                       2025-11-09 18:02:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                        2025-11-22 17:08:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                        2025-11-27 18:40:59 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                         2025-11-27 18:59:55 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                          2025-11-27 20:07:34 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                           2025-11-28 14:50:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                            2025-11-28 16:57:55 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                             2025-11-28 17:58:46 from Hannu Krosing <hannuk(at)google(dot)com>                                                                              2025-11-28 18:05:12 from Hannu Krosing <hannuk(at)google(dot)com>                                                                               2025-11-28 18:40:45 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                               2025-12-01 10:29:49 from Antonin Houska <ah(at)cybertec(dot)at>                                                                                2025-12-01 10:49:37 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                                 2025-12-02 07:28:00 from Antonin Houska <ah(at)cybertec(dot)at>                                                                                  2025-12-02 10:27:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                                   2025-12-02 11:12:17 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                                    2026-01-15 22:04:19 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                                     2026-02-24 19:48:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                                      2026-03-09 00:09:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                                       2026-03-23 22:08:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                                        2026-03-28 19:17:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                                                                              2025-11-28 18:31:17 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                               2025-11-28 19:08:12 from Hannu Krosing <hannuk(at)google(dot)com>                                                                                2025-11-28 20:41:15 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                                 2025-11-28 21:01:04 from Hannu Krosing <hannuk(at)google(dot)com>                                                                                2025-12-02 12:02:32 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                             2025-12-01 09:09:29 from Antonin Houska <ah(at)cybertec(dot)at>                                                                              2025-12-02 10:51:06 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                               2025-12-04 08:34:54 from Antonin Houska <ah(at)cybertec(dot)at>                                                                                2025-12-04 16:32:48 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                                 2025-12-04 19:15:44 from Antonin Houska <ah(at)cybertec(dot)at>                                                                                  2025-12-04 21:03:33 from Hannu Krosing <hannuk(at)google(dot)com>                                                                                   2025-12-16 13:43:53 from Heikki Linnakangas <hlinnaka(at)iki(dot)fi>                                                                                    2025-12-16 21:58:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                                                                                    2025-12-17 18:22:56 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>                                                                                     2026-01-12 14:12:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                 2024-02-21 11:01:45 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>  2025-11-27 16:56:25 from Antonin Houska <ah(at)cybertec(dot)at>   2025-11-27 17:40:34 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>    2025-11-27 18:57:23 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>   2025-11-27 18:22:46 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>    2025-11-28 09:05:24 from Antonin Houska <ah(at)cybertec(dot)at>     2025-11-28 09:51:16 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v31-0003-Add-Datum-storage-support-to-tuplestore-Extend-t.patch	application/octet-stream	21.0 KB
v31-0002-Add-STIR-access-method-and-flags-related-to-auxi.patch	application/octet-stream	36.4 KB
v31-0004-Use-auxiliary-indexes-for-concurrent-index-opera.patch	application/octet-stream	94.9 KB
v31-0005-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch	application/octet-stream	30.9 KB
v31-0001-Add-stress-tests-for-concurrent-index-builds.patch	application/octet-stream	11.9 KB
v31-0006-Optimize-auxiliary-index-handling.patch	application/octet-stream	2.1 KB
v31-0007-Refresh-snapshot-periodically-during-index-valid.patch	application/octet-stream	22.5 KB

In response to

• Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements at 2026-03-09 00:09:00 from Mihail Nikalayeu

Responses

• Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements at 2026-03-28 19:17:00 from Mihail Nikalayeu

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Steve Chavez	2026-03-23 22:23:59	[PATCH] refactor ExecCheckPermissionsModified for ACL_SELECT
Previous Message	Melanie Plageman	2026-03-23 21:54:13	Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)