On Sat, Aug 20, 2022, 12:02 PM J T <jorge.torralba@xxxxxxxxx> wrote:
Having an issue on Postgres 11.16 where occasionally, we start seeing a pile up of simple inserts or select just hanging and never complete. These single table insert on conflict do nothing. it gets to the point where one cannot even pg_terminate_backend. It's impossible to kill without a kill -9 and we know we don't want to do that for obvious reasons.
Although this is not what we do all the times, but just in case , and report it as bug either in pg or extension etc if it is.