Received: from as.tksoft.com (gyw.com [209.55.67.177] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id SAA10896 for ; Tue, 16 Nov 1999 18:23:21 -0500 (EST) (envelope-from tjk@tksoft.com) Received: (from tjk@tksoft.com) by uno.tksoft.com (8.8.8/8.8.8) id PAA14773; Tue, 16 Nov 1999 15:00:13 -0800 From: "tjk@tksoft.com" Message-Id: <199911162300.PAA14773@uno.tksoft.com> Subject: Re: [SQL] zombie postmasters To: hamid@emarq.com (Hamid Khoshnevis) Date: Tue, 16 Nov 1999 15:00:13 -0800 (PST) Cc: pgsql-sql@postgreSQL.org In-Reply-To: <000201bf3087$3afadae0$810a0a0a@hamid.emarq> from "Hamid Khoshnevis" at Nov 16, 99 03:06:35 pm Content-Type: text You can place timeouts on the queries and terminate the query if it takes too long. Troy > > 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 > > > ************ > >