Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

From:	Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To:	Sergey Sargsyan <sergey(dot)sargsyan(dot)2001(at)gmail(dot)com>
Cc:	Á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>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Subject:	Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
Date:	2025-09-28 09:26:00
Message-ID:	CADzfLwWbV1i7+cP_Hqr3qgQnBXkAqgrCQxd5PFzqp2AOTK=40w@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> 📎                 2024-02-21 11:01:45 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
nocfbot-v24-only-part-3-0005-Optimize-auxiliary-index-handling.patch	application/octet-stream	2.4 KB
nocfbot-v24-only-part-3-0001-Add-STIR-access-method-and-flags-rel.patch	application/octet-stream	37.3 KB
nocfbot-v24-only-part-3-0003-Use-auxiliary-indexes-for-concurrent.patch	application/octet-stream	94.4 KB
nocfbot-v24-only-part-3-0002-Add-Datum-storage-support-to-tuplest.patch	application/octet-stream	19.0 KB
nocfbot-v24-only-part-3-0004-Track-and-drop-auxiliary-indexes-in-.patch	application/octet-stream	30.5 KB
nocfbot-v24-only-part-3-0006-Refresh-snapshot-periodically-during.patch	application/octet-stream	21.1 KB
v24-0002-Add-stress-tests-for-concurrent-index-builds.patch	application/octet-stream	9.1 KB
v24-0003-Reset-snapshots-periodically-in-non-unique-non-p.patch	application/octet-stream	46.2 KB
v24-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch	application/octet-stream	23.2 KB
v24-0005-Support-snapshot-resets-in-concurrent-builds-of-.patch	application/octet-stream	39.7 KB
v24-0004-Support-snapshot-resets-in-parallel-concurrent-i.patch	application/octet-stream	41.2 KB
v24-0006-Add-STIR-access-method-and-flags-related-to-auxi.patch	application/octet-stream	37.3 KB
v24-0007-Add-Datum-storage-support-to-tuplestore.patch	application/octet-stream	19.0 KB
v24-0008-Use-auxiliary-indexes-for-concurrent-index-opera.patch	application/octet-stream	94.4 KB
v24-0011-Refresh-snapshot-periodically-during-index-valid.patch	application/octet-stream	23.5 KB
v24-0010-Optimize-auxiliary-index-handling.patch	application/octet-stream	2.4 KB
v24-0009-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch	application/octet-stream	30.5 KB
v24-0012-Remove-PROC_IN_SAFE_IC-optimization.patch	application/octet-stream	21.2 KB

In response to

• Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements at 2025-09-05 00:25:56 from Mihail Nikalayeu

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Chao Li	2025-09-28 09:33:56	Re: Add jsonb_translate(jsonb, from, to)
Previous Message	Dmitry Dolgov	2025-09-28 09:24:26	Re: Changing shared_buffers without restart