Re: Zombie process pile up and cannot terminate - Mailing list pgsql-admin

From Vijaykumar Jain
Subject Re: Zombie process pile up and cannot terminate
Date
Msg-id CAM+6J962poE3S7X5WiEQ3ne4TG8EiRdeQx++eVVg7D1pG0C57A@mail.gmail.com
Whole thread Raw
In response to Zombie process pile up and cannot terminate  (J T <jorge.torralba@gmail.com>)
List pgsql-admin


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


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.

pgsql-admin by date:

Previous
From: J T
Date:
Subject: Zombie process pile up and cannot terminate
Next
From: Kenny Bachman
Date:
Subject: Postgresql 14 performance