PostgreSQL and Windows2000 and defunct processes
Steven Vajdic <svajdic@asc.corp.mot.com>
From: Steven Vajdic <svajdic@asc.corp.mot.com>
To: pgsql-general@postgresql.org, pgsql-hackers@postgresql.org, svajdic@asc.corp.mot.com, steven_vajdic@yahoo.com.au
Date: 2002-06-06T06:53:29Z
Lists: pgsql-hackers, 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!!!???