Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 428C42E0033 for ; Mon, 18 Feb 2008 09:46:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42333-04 for ; Mon, 18 Feb 2008 09:46:34 -0400 (AST) Received: from easy2.in-chemnitz.de (easy2.in-chemnitz.de [88.198.17.232]) by postgresql.org (Postfix) with ESMTP id 627F42E002C for ; Mon, 18 Feb 2008 09:46:34 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by easy2.in-chemnitz.de (Postfix) with ESMTP id 36DE2B28A8 for ; Mon, 18 Feb 2008 14:46:32 +0100 (CET) Received: from easy2.in-chemnitz.de ([127.0.0.1]) by localhost (easy.in-chemnitz.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0T2AG2pRHa3W for ; Mon, 18 Feb 2008 14:46:32 +0100 (CET) Received: by easy2.in-chemnitz.de (Postfix, from userid 1013) id 1E06DB2899; Mon, 18 Feb 2008 14:46:30 +0100 (CET) Date: Mon, 18 Feb 2008 14:46:30 +0100 From: Tino Schwarze To: pgsql-admin@postgresql.org Subject: Re: Processes running without cleaning Message-ID: <20080218134630.GC23416@easy2.in-chemnitz.de> References: <3D5445983859B84B92669C0D883EA6FB0C4F0451@ZENMAILHQ1.ind.zensar.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0C4F0451@ZENMAILHQ1.ind.zensar.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/185 X-Sequence-Number: 28259 On Mon, Feb 18, 2008 at 06:30:38PM +0530, Suresh Gupta VG wrote: > Can you please any one explain, how the processes will go when we give > the options for blocks and nodes. As a common, we find 3 processes > running as parent processes of pgsql. Pls find the list of processes in > the attachment.(max_connction = 100 is configured in the postgresql > configuration file. Why cleaning up of process is not happening? The processes will go away when the connection is closed, so it looks like your application is not closing connections correctly. HTH! Tino. PS: Rather than specifying -N and -B on command line, I would set the appropiate options in postgresql.conf - max_connections and shared_buffers. -- www.craniosacralzentrum.de www.spiritualdesign-chemnitz.de www.forteego.de Tino Schwarze * Lortzingstraße 21 * 09119 Chemnitz