Re: Why is this system swapping?

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: "Anjan Dave" <adave(at)vantage(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Why is this system swapping?
Date: 2005-04-27 19:28:56
Message-ID: cbe3ad2481e7cf5fcde552427c98f540@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message John A Meinel 2005-04-27 19:43:48 Re: Final decision
Previous Message Steve Poe 2005-04-27 19:15:38 Re: Final decision