To: pgsql-performance@postgresql.org
From: Mark Stosberg <mark@summersault.com>
Subject: recommendations for web/db connection pooling or DBD::Gofer reviews
Date: Mon, 07 Apr 2008 14:36:00 -0400
Lines: 21
Message-ID: <ftdpih$nid$2@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Thunderbird 2.0.0.12 (X11/20080227)


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