Received: from dagny.surfsouth.com (cmiller@dagny.surfsouth.com [205.139.60.173]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA10810 for ; Tue, 16 Nov 1999 18:22:05 -0500 (EST) (envelope-from cmiller@dagny.surfsouth.com) Received: (from cmiller@localhost) by dagny.surfsouth.com (8.9.3/8.8.8) id SAA01207; Tue, 16 Nov 1999 18:21:59 -0500 Date: Tue, 16 Nov 1999 18:21:59 -0500 From: Chad Miller To: Hamid Khoshnevis Cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] zombie postmasters Message-ID: <19991116182159.A1202@surfsouth.com> References: <000201bf3087$3afadae0$810a0a0a@hamid.emarq> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.6i In-Reply-To: <000201bf3087$3afadae0$810a0a0a@hamid.emarq>; from Hamid Khoshnevis on Tue, Nov 16, 1999 at 03:06:35PM -0800 X-mom-quote: Finish that packet--children are offline in India! X-lament: There just aren't enough clock-cycles in a day. X-project: Building a machine with a lot of computrons. Not a direct answer, but... I think zombies (under most, if not all unices) don't use resources, other than the PID. - chad On Tue, Nov 16, 1999 at 03:06:35PM -0800, Hamid Khoshnevis wrote: > Hello to all, > In a web environment, a user can repeatedly starts and abort large queries > which create a large number of zombie postmasters. Is there a way to > control the postmaster zombies so that they don't clog up the system > resources. > > thanks, > > hamid > > Hamid Khoshnevis > emarQ.com > 1488-1188 W. Georgia St. > Vancouver, BC V6E 4A2, Canada > Ph: (604) 687-7111 > Fx: (604) 687-7222 > http://www.emarq.com > hamid@emarq.com > > > ************ >