PostgreSQL and Windows2000 and defunct processes - Mailing list pgsql-general

From Steven Vajdic
Subject PostgreSQL and Windows2000 and defunct processes
Date
Msg-id 3CFF06E9.F3CA9622@asc.corp.mot.com
Whole thread Raw
Responses Re: [HACKERS] PostgreSQL and Windows2000 and defunct processes
List 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 by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: View vs. Statement Query Plan
Next
From: "Nicolas Nolst"
Date:
Subject: performance issue using DBI