Followup: Here's why I want to use connection pooling middleware!

On Thursday 15 January 2009 09:54:50 Kirk Strauser wrote:
> I have a PostgreSQL 8.3.5 server with max_connections = 400. At this
> moment, I have 223 open connections, including 64 from a bunch of
> webserver processes and about 100 from desktop machines running a
> particular application. The rest are from various scheduled processes
> and other assorted things. Now, I know there are projects like pgpool-
> II that can serve to pool connections to the server. Why would I want
> to do that, though?

After installing and configuring PgBouncer and then pointing all of our clients
at it, our average number of database connections has dropped from 250+ to 17.
Query times are also much better, and more RAM is going to caching than to
holding processes. Count me as a new fan.
--
Kirk Strauser