On Wed, Jun 12, 2024 at 03:02:43PM +0200, Michail Nikolaev wrote:
> I am not sure, but I think that issue may be related to the issue described
> in
> https://www.postgresql.org/message-id/CANtu0ojXmqjmEzp-%3DaJSxjsdE76iAsRgHBoK0QtYHimb_mEfsg%40mail.gmail.com
>
> It looks like REINDEX CONCURRENTLY could interfere with ON CONFLICT UPDATE
> in some strange way.
Can you say more about the connection you see between $SUBJECT and that? That
looks like a valid report of an important bug, but I'm not following the
potential relationship to $SUBJECT.
On your other thread, it would be useful to see stack traces from the high-CPU
processes once the live lock has ended all query completion.