Re: recommendations for web/db connection pooling or DBD::Gofer reviews - Mailing list pgsql-performance

From Vivek Khera
Subject Re: recommendations for web/db connection pooling or DBD::Gofer reviews
Date
Msg-id EAAE30B3-2D43-498F-B1C0-9E5CA8A3EE60@khera.org
Whole thread Raw
In response to Re: recommendations for web/db connection pooling or DBD::Gofer reviews  (Mark Stosberg <mark@summersault.com>)
List pgsql-performance
On Apr 10, 2008, at 5:28 PM, Mark Stosberg wrote:
> So, the front-end proxy would have a number of max connections, say
> 200,  and it would connect to another httpd/mod_perl server behind
> with a lower number of connections, say 20. If the backend httpd
> server was busy, the proxy connection to it would just wait in a
> queue until it was available.

If you read the mod_perl performance tuning guide, it will tell you to
do exactly this.  These are solved problems for many, many years now.
The apache mod_proxy really does wonders...


pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Creating large database of MD5 hash values
Next
From: Gregory Stark
Date:
Subject: Re: Performance increase with elevator=deadline