[Pgpool-general] pgpool II and loads

[Kenneth Marshall]

On Mon, May 28, 2007 at 09:43:45AM -0700, Jacob Olsen wrote:
> Hi,
> 
> I installed pgpool II on four webservers last night and set it to open
> 80 connections each to two database servers.
> 
> My question is, what causes a huge spike in the load on webservers? I'm
> seeing loads > 15 in top, which I never saw before pgpool.
> 
> Some more info:
> 
> Each postgresql installation is set to handle 350 connections, and I've
> verified only 80 are being opened from each webserver on each database
> server.
> 
> Thanks so much to anyone that can help!
> 
> --jake
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
> 
Jake,

Assuming that your DB servers can support 320 simultaneous connections,
your webservers may now able to reply more efficiently to the client
requests and can therefore service more requests per unit time. This
will translate directly to a higher load on the webservers. Do you have
metrics of the webserver performance before and after rolling out pgpool?

My 2 cents.
Ken