Re: [SQL] zombie postmasters

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [SQL] zombie postmasters
Дата
Msg-id 24411.942815127@sss.pgh.pa.us
обсуждение исходный текст
Ответ на zombie postmasters  ("Hamid Khoshnevis" <hamid@emarq.com>)
Ответы Re: [SQL] zombie postmasters  (wieck@debis.com (Jan Wieck))
Re: [SQL] zombie postmasters  (Zalman Stern <zalman@netcom.com>)
Список pgsql-sql
"Hamid Khoshnevis" <hamid@emarq.com> writes:
> In a web environment, a user can repeatedly starts and abort large queries
> which create a large number of zombie postmasters.

It shouldn't be possible for there to be zombie postgres processes ---
the postmaster process should reap dead backends more or less instantly.
Either your postmaster is getting wedged somehow, or there is a
configure/install problem that has broken the postmaster's handling
of child-process exit.  What platform are you using, exactly?  What
if anything shows up in the postmaster log when this happens?
        regards, tom lane


В списке pgsql-sql по дате отправления:

Предыдущее
От: maxsbox
Дата:
Сообщение: ODBC/Openlink/Delphi
Следующее
От: "Gary MacMinn"
Дата:
Сообщение: Re: [SQL] nulls and datetime