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.
