Re: Postgresql with max_connections=4096 - Mailing list pgsql-general

From Jeff Trout
Subject Re: Postgresql with max_connections=4096
Date
Msg-id FB06A093-7F0F-4407-AC62-B850994CAA27@torgo.978.org
Whole thread Raw
In response to Re: Postgresql with max_connections=4096  (denis@edistar.com)
Responses Re: Postgresql with max_connections=4096
List pgsql-general
On Jul 27, 2005, at 10:46 AM, denis@edistar.com wrote:

> I'm now testing with pg_pool installed on each apache frontend with
> 260 pg_pool preforked clients in each machine.

Why did you pick 260?

You don't need a 1:1 ratio. That is the point of the pool. Those
connections are "shared".  Chances are extremely high that all your
apache clients are not issuing queries at the same exact time so your
queries end up getting funnelled into those X  connections.

I ran with 32 kids on pg_pool and 350 apache processes. never had a
problem.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Wishlist?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Backup and restore from 7.4.1 to latest, crossing platforms... issues?