Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY

From:	Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To:	Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>
Cc:	Michael Paquier <michael(at)paquier(dot)xyz>, Noah Misch <noah(at)leadboat(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
Date:	2025-05-18 15:16:00
Message-ID:	CADzfLwWtK9R3GvEp7ANfO3pE3dbpD3T99f9aGFMwV4HSerHE5w@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2024-06-11 11:00:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎  2024-06-13 23:18:15 from Michael Paquier <michael(at)paquier(dot)xyz>   2024-06-14 10:06:13 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>    2024-06-14 13:30:55 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎     2024-06-17 17:00:51 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎      2024-06-21 06:53:45 from Michael Paquier <michael(at)paquier(dot)xyz>       2024-06-21 09:31:21 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>        2024-06-25 01:14:16 from Michael Paquier <michael(at)paquier(dot)xyz>         2024-06-25 11:47:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>          2024-06-25 15:57:22 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>           2024-08-07 09:30:44 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎            2024-08-16 10:22:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎             2024-08-24 15:52:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎              2024-11-14 23:38:37 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎               2024-11-28 21:29:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                2025-01-13 21:58:00 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                 2025-01-18 12:59:35 from Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com> 📎                  2025-02-20 12:19:50 from Міхаіл Нікалаеў <mihailnikalayeu(at)gmail(dot)com> 📎                   2025-05-18 15:16:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                    2025-10-20 19:27:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                     2025-10-27 18:06:06 from Noah Misch <noah(at)leadboat(dot)com>                      2025-10-28 01:19:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                       2025-11-02 23:21:05 from Noah Misch <noah(at)leadboat(dot)com> 📎                        2025-11-03 20:41:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                         2025-11-03 22:52:05 from Noah Misch <noah(at)leadboat(dot)com>                          2025-11-03 23:03:15 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                           2025-11-09 11:20:11 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎              2025-11-22 12:29:12 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>               2025-11-22 14:06:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                2025-11-22 14:16:44 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                 2025-11-22 23:17:20 from Michael Paquier <michael(at)paquier(dot)xyz>                  2025-11-23 12:14:37 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                   2025-11-23 23:36:09 from Michael Paquier <michael(at)paquier(dot)xyz>                2025-11-24 17:49:47 from Álvaro Herrera <alvherre(at)kurilemu(dot)de> 📎                 2025-11-24 22:15:19 from Michael Paquier <michael(at)paquier(dot)xyz>                 2025-11-24 22:24:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                  2025-11-25 17:45:35 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                2025-11-26 18:34:16 from Álvaro Herrera <alvherre(at)kurilemu(dot)de> 📎                 2025-11-27 01:54:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                  2025-11-27 12:32:44 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                   2025-11-30 17:00:01 from Alexander Lakhin <exclusion(at)gmail(dot)com> 📎                    2025-11-30 17:26:18 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                     2025-12-01 11:27:46 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                      2025-12-02 13:07:47 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                       2025-12-06 06:00:01 from Alexander Lakhin <exclusion(at)gmail(dot)com>                        2025-12-06 11:22:37 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                         2025-12-07 21:07:45 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                          2025-12-07 22:18:22 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                          2025-12-07 23:29:12 from Michael Paquier <michael(at)paquier(dot)xyz>                         2025-12-08 09:58:33 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                          2025-12-08 11:34:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                           2025-12-09 19:45:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                            2025-12-11 20:04:15 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                      2025-12-02 15:46:41 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                      2025-12-02 15:51:59 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                       2025-12-02 16:04:39 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                       2025-12-03 04:43:48 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                        2025-12-03 10:22:13 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                         2025-12-03 14:27:20 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                         2025-12-03 15:56:32 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                         2025-12-04 17:43:27 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                          2025-12-04 17:59:53 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                           2025-12-05 15:20:57 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                2025-11-28 17:30:40 from Álvaro Herrera <alvherre(at)kurilemu(dot)de> 📎                 2025-11-28 18:09:03 from Hannu Krosing <hannuk(at)google(dot)com>                  2025-11-28 18:42:31 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                 2025-11-28 18:21:06 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                 2025-11-28 20:12:15 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                  2025-11-28 20:51:44 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                2025-11-29 17:48:55 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                 2025-11-30 12:11:06 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                  2025-11-30 16:52:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                2025-12-11 21:36:55 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                 2025-12-12 00:06:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                  2025-12-12 10:17:30 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                   2025-12-13 17:00:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                 2025-12-14 15:19:21 from Andres Freund <andres(at)anarazel(dot)de>                  2025-12-14 15:50:31 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>                   2025-12-15 11:30:58 from Álvaro Herrera <alvherre(at)kurilemu(dot)de>                    2025-12-16 02:48:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                     2025-12-17 11:35:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎                      2025-12-19 01:24:00 from Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com> 📎      2024-06-24 07:06:21 from Michael Paquier <michael(at)paquier(dot)xyz> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v9-0004-Modify-the-ExecInitPartitionInfo-function-to-cons.patch	application/octet-stream	6.1 KB
v9-0001-Specs-to-reproduce-the-issues-with-CREATE-INDEX-C.patch	application/octet-stream	49.0 KB
v9-0002-Modify-the-infer_arbiter_indexes-function-to-cons.patch	application/octet-stream	2.9 KB
v9-0003-Modify-the-infer_arbiter_indexes-function-to-also.patch	application/octet-stream	8.1 KB

In response to

• Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY at 2025-02-20 12:19:50 from Міхаіл Нікалаеў

Responses

• Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY at 2025-10-20 19:27:00 from Mihail Nikalayeu

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Sadeq Dousti	2025-05-18 15:56:24	Re: Possible regression in PG18 beta1
Previous Message	Mihail Nikalayeu	2025-05-18 15:09:00	Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements