PostgreSQL and Windows2000 and defunct processes

Поиск
Список
Период
Сортировка
От Steven Vajdic
Тема PostgreSQL and Windows2000 and defunct processes
Дата
Msg-id 3CFF06E9.F3CA9622@asc.corp.mot.com
обсуждение исходный текст
Ответы Re: [HACKERS] PostgreSQL and Windows2000 and defunct processes  (Yutaka tanida <yutaka@hi-net.zaq.ne.jp>)
Список pgsql-general

Problem:

Win2000 and Cygwin/postgresql-7.1 produce
"defunct" processes after each run which can ONLY be killed
by Win Task Manager. If you allow too many "defunct" processes
your database requests slow down and your number of connections
increases, i.e. if you
have 32 connections specified in your postgresql.conf file and
and 32 "defunct" processes and try to run again
the connection will be refused.
When you are killing "defunct" processes and reach the one which was
first formed
the postmaster restarts postgresql.

How to get read of those "defunct" processes?

Much obliged.

Steven.

P.S. You do not have these "defunct" processes under Win98!!!???


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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: View vs. Statement Query Plan
Следующее
От: "Nicolas Nolst"
Дата:
Сообщение: performance issue using DBI