Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

From:	Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To:	Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>
Cc:	alvherre(at)alvh(dot)no-ip(dot)org, 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-05-18 15:09:00
Message-ID:	CADzfLwW9QczZW-E=McxcjUv0e5VMDctQNETbgao0K-SimVhFPA@mail.gmail.com
Views:	Raw Message | Whole Thread | 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>                 2024-02-21 11:01:45 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v19-0009-Track-and-drop-auxiliary-indexes-in-DROP-REINDEX.patch	application/octet-stream	28.7 KB
v19-0012-Remove-PROC_IN_SAFE_IC-optimization.patch	application/octet-stream	21.3 KB
v19-0010-Optimize-auxiliary-index-handling.patch	application/octet-stream	2.4 KB
v19-0008-Use-auxiliary-indexes-for-concurrent-index-opera.patch	application/octet-stream	96.8 KB
v19-0011-Refresh-snapshot-periodically-during-index-valid.patch	application/octet-stream	32.1 KB
v19-0006-Add-STIR-access-method-and-flags-related-to-auxi.patch	application/octet-stream	36.9 KB
v19-0007-Add-Datum-storage-support-to-tuplestore.patch	application/octet-stream	17.3 KB
v19-0005-Support-snapshot-resets-in-concurrent-builds-of-.patch	application/octet-stream	39.4 KB
v19-0004-Support-snapshot-resets-in-parallel-concurrent-i.patch	application/octet-stream	41.2 KB
v19-0003-Reset-snapshots-periodically-in-non-unique-non-p.patch	application/octet-stream	46.1 KB
v19-0002-Add-stress-tests-for-concurrent-index-builds.patch	application/octet-stream	9.1 KB
v19-only-part-3-0005-Optimize-auxiliary-index-handling.patch_	application/octet-stream	2.4 KB
v19-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch	application/octet-stream	25.3 KB
v19-only-part-3-0004-Track-and-drop-auxiliary-indexes-in-.patch_	application/octet-stream	28.7 KB
v19-only-part-3-0006-Refresh-snapshot-periodically-during.patch_	application/octet-stream	20.7 KB
v19-only-part-3-0001-Add-STIR-access-method-and-flags-rel.patch_	application/octet-stream	36.9 KB
v19-only-part-3-0002-Add-Datum-storage-support-to-tuplest.patch_	application/octet-stream	17.3 KB
v19-only-part-3-0003-Use-auxiliary-indexes-for-concurrent.patch_	application/octet-stream	96.9 KB
STIR-poster.pdf	application/pdf	1.5 MB

In response to

• Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements at 2025-04-30 20:01:24 from Mihail Nikalayeu

Responses

• Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements at 2025-05-18 15:56:54 from Álvaro Herrera

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Mihail Nikalayeu	2025-05-18 15:16:00	Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
Previous Message	Sami Imseih	2025-05-18 14:52:20	Re: Possible regression in PG18 beta1