Re: Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY

From: Mihail Nikalayeu <mihailnikalayeu(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Andres Freund <andres(at)anarazel(dot)de>, 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-12-19 01:24:00
Message-ID: CADzfLwW3UTDBUgi=oai-YVk-AtZR0R3OV+Mba-DTvottsMAfHw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, Álvaro and others!

Attached version feels stable enough so far - 20 builds in a row on
all CI variants (including 3 BSD) - no failures so far.

I updated the commit message to include reference to previous commits.
Also, tests designed in a way to fail fast if something is going wrong
+ log some debug information in that case (active queries with its
states).

Special tricks to handle forced-cache release builds included too.

Also, there is a test which "breaks" all the fixes - to ensure the
test actually catches them, not intended to be committed of course.

Best regards,
Mikhail.

Attachment Content-Type Size
v2-0001-Replace-flaky-CIC-RI-isolation-tests-with-stable-.patch application/x-patch 91.7 KB
nocfbot-0002-DO-NOT-PUSH-IT.patch application/x-patch 1.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2025-12-19 01:43:10 Switch buffile.c/h to use pgoff_t
Previous Message Sami Imseih 2025-12-19 00:44:17 Refactor query normalization into core query jumbling