Re: [SQL] zombie postmasters

Поиск
Список
Период
Сортировка
От Zalman Stern
Тема Re: [SQL] zombie postmasters
Дата
Msg-id 199911170844.AAA25336@netcom.com
обсуждение исходный текст
Ответ на Re: [SQL] zombie postmasters  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.

The first question is whether you mean real "zombies" (as indicated by ps)
or a bunch more process than you expected ("process leak"). I've seen the
latter a number of times and it generally indicates failure to properly
close connections in your application. I find the same techniques used for
debuging file descriptor leaks work for finding these problems.

-Z-


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

Предыдущее
От: wieck@debis.com (Jan Wieck)
Дата:
Сообщение: Re: [SQL] zombie postmasters
Следующее
От: jose soares
Дата:
Сообщение: Re: [SQL] ODBC/Openlink/Delphi