Search Postgresql Archives

Re: Postgresql with max_connections=4096

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Jul 27, 2005, at 10:46 AM, denis@xxxxxxxxxxx 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@xxxxxxxxxxxxx>
http://www.jefftrout.com/
http://www.stuarthamm.net/



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux