Re: Why is this system swapping? - Mailing list pgsql-performance

From Jeff
Subject Re: Why is this system swapping?
Date
Msg-id cbe3ad2481e7cf5fcde552427c98f540@torgo.978.org
Whole thread Raw
In response to Re: Why is this system swapping?  (Greg Stark <gsstark@mit.edu>)
Responses Re: Why is this system swapping?  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
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 <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/


pgsql-performance by date:

Previous
From: Steve Poe
Date:
Subject: Re: Final decision
Next
From: John A Meinel
Date:
Subject: Re: Final decision