X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B44EB535B4 for ; Wed, 27 Apr 2005 16:29:10 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 97696-10 for ; Wed, 27 Apr 2005 19:29:01 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id B3C5A535D0 for ; Wed, 27 Apr 2005 16:28:56 -0300 (ADT) Received: from jefftrout.com ([24.61.201.181]) by comcast.net (rwcrmhc12) with SMTP id <2005042719285601400ksnebe>; Wed, 27 Apr 2005 19:28:57 +0000 Received: (qmail 27792 invoked from network); 27 Apr 2005 19:29:34 -0000 Received: from waltham-nat.ma.lycos.com (HELO ?10.124.7.194?) (209.202.205.1) by 192.168.0.109 with SMTP; 27 Apr 2005 19:29:34 -0000 In-Reply-To: <8764y83wg7.fsf@stark.xeocode.com> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78509899C@vt-pe2550-001.vantage.vantage.com> <8764y83wg7.fsf@stark.xeocode.com> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Cc: "Anjan Dave" , From: Jeff Subject: Re: Why is this system swapping? Date: Wed, 27 Apr 2005 15:28:56 -0400 To: Greg Stark X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.185 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP, RCVD_IN_SORBS_DUL X-Spam-Level: X-Archive-Number: 200504/744 X-Sequence-Number: 12141 On Apr 27, 2005, at 2:29 PM, Greg Stark wrote: > "AI would seriously look at tuning those connection pools down. A lot. > If your > server processes are sitting idle over half the time I would at least > cut it > by a factor of 2. > Are you (Anjan) using real or fake connection pooling - ie pgpool versus php's persistent connections ? I'd strongly recommend looking at pgpool. it does connection pooling correctly (A set of X connections shared among the entire box rather than 1 per web server) -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/