Re: Zombie process pile up and cannot terminate

On Sat, Aug 20, 2022, 12:02 PM J T <jorge(dot)torralba(at)gmail(dot)com> 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.
>

https://www.cybertec-postgresql.com/en/cancel-hanging-postgresql-query/

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.

>