From: Mark Stosberg <mark@summersault.com>
To: pgsql-performance@postgresql.org
Subject: recommendations for web/db connection pooling or DBD::Gofer reviews
Date: Mon, 07 Apr 2008 14:36:00 -0400
Message-ID: <ftdpih$nid$2@ger.gmane.org> (raw)
When traffic to our PostgreSQL-backed website spikes, the first resource
we see being exhausted is the DB slots on the master server (currently
set to about 400).
I expect that as new Apache/mod_perl children are being put to us, they
are creating new database connections.
I'm interested in recommendations to funnel more of that traffic through
fewer DB slots, if that's possible. (We could also consider increasing
the handles available, since the DB server has some CPU and memory to
spare).
I'm particularly interested in review of DBD::Gofer, which seems like it
would help with this in our Perl application:
http://search.cpan.org/dist/DBI/lib/DBD/Gofer.pm
I realize it has limitations, like "no transactions", but I think we
would still able to use it selectively in our application.
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark@summersault.com
Subject: Re: recommendations for web/db connection pooling or DBD::Gofer reviews
In-Reply-To: <ftdpih$nid$2@ger.gmane.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox