Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 768222E01E8 for ; Wed, 30 Jan 2008 10:53:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 20043-10 for ; Wed, 30 Jan 2008 10:53:33 -0400 (AST) Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 16C782E0119 for ; Wed, 30 Jan 2008 10:53:41 -0400 (AST) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Wed, 30 Jan 2008 08:53:39 -0600 Message-Id: <47A03B08.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Wed, 30 Jan 2008 08:53:29 -0600 From: "Kevin Grittner" To: "Honza Novak" , Subject: Re: connection from connection pool uses too much memory during the time References: <47A0490D.4020301@developers.zlutazimnice.cz> In-Reply-To: <47A0490D.4020301@developers.zlutazimnice.cz> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/286 X-Sequence-Number: 28060 >>> On Wed, Jan 30, 2008 at 3:53 AM, in message <47A0490D.4020301@developers.zlutazimnice.cz>, Honza Novak wrote:=20 =20 > The problem is that it looks=20 > like, that once the open connection takes some memory, it never gives=20 > that memory back, which ends up with our server swapping large amounts=20= > of memory. =20 What operating system? =20 How are you looking at the RAM usage? =20 Many people are confused when seeing the OS cache usage when running PostgreSQL. That's normal and is not a problem. =20 -Kevin =20