Re: Zombie process pile up and cannot terminate

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: Zombie process pile up and cannot terminate
Дата
Msg-id CAM+6J962poE3S7X5WiEQ3ne4TG8EiRdeQx++eVVg7D1pG0C57A@mail.gmail.com
обсуждение исходный текст
Ответ на Zombie process pile up and cannot terminate  (J T <jorge.torralba@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: J T
Дата:
Сообщение: Zombie process pile up and cannot terminate
Следующее
От: Kenny Bachman
Дата:
Сообщение: Postgresql 14 performance