Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

From:	Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>
To:	Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
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-03-07 22:58:51
Message-ID:	CANtu0ogiQ8xXncFmWTC5LJS65o6nTaVVb84q4f_S_GxCjVsDVw@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> 📎                 2024-02-21 11:01:45 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v16-0009-Concurrently-built-index-validation-uses-fresh-s.patch	application/octet-stream	14.1 KB
v16-0008-Improve-CREATE-REINDEX-INDEX-CONCURRENTLY-using-.patch	application/octet-stream	109.9 KB
v16-0011-Add-proper-handling-of-auxiliary-indexes-during-.patch	application/octet-stream	28.7 KB
v16-0012-Updates-index-insert-and-value-computation-logic.patch	application/octet-stream	2.2 KB
v16-0010-Remove-PROC_IN_SAFE_IC-optimization.patch	application/octet-stream	21.4 KB
v16-0007-tuplestore-add-support-for-storing-Datum-values.patch	application/octet-stream	17.3 KB
v16-0005-Allow-snapshot-resets-in-concurrent-unique-index.patch	application/octet-stream	39.0 KB
v16-0006-Add-STIR-Short-Term-Index-Replacement-access-met.patch	application/octet-stream	37.0 KB
v16-0004-Allow-snapshot-resets-during-parallel-concurrent.patch	application/octet-stream	41.5 KB
v16-0002-Add-stress-tests-for-concurrent-index-operations.patch	application/octet-stream	8.1 KB
v16-0003-Allow-advancing-xmin-during-non-unique-non-paral.patch	application/octet-stream	46.8 KB
v16-0001-This-is-https-commitfest.postgresql.org-50-5160-.patch	application/octet-stream	17.5 KB

In response to

• Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements at 2025-02-20 14:56:20 from Mihail Nikalayeu

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Jacob Champion	2025-03-07 23:02:50	Re: [PoC] Federated Authn/z with OAUTHBEARER
Previous Message	Matthias van de Meent	2025-03-07 22:47:45	Re: Expanding HOT updates for expression and partial indexes