From: Martin Foster <martin@ethereal-realms.org>
To: Kevin Barnard <kevin.barnard@gmail.com>
Cc: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Restricting Postgres
Date: Thu, 04 Nov 2004 11:15:12 -0500
Message-ID: <418A5590.5090006@ethereal-realms.org> (raw)
In-Reply-To: <b068057c041104080051ccc451@mail.gmail.com>
References: <M4Vhd.85137$9b.34888@edtnps84>
<1099509684.4320.2.camel@localhost.localdomain>
<41894CD9.8090308@ethereal-realms.org>
<1099570740.4320.196.camel@localhost.localdomain>
<418A2BE2.70609@ethereal-realms.org>
<b068057c041104080051ccc451@mail.gmail.com>
Kevin Barnard wrote:
> I am generally interested in a good solution for this. So far our
> solution has been to increase the hardware to the point of allowing
> 800 connections to the DB.
>
> I don't have the mod loaded for Apache, but we haven't had too many
> problems there. The site is split pretty good between dynamic and
> non-dynamic, it's largely Flash with several plugins to the DB.
> However we still can and have been slammed and up to point of the 800
> connections.
>
> What I don't get is why not use pgpool? This should eliminate the
> rapid fire forking of postgres instanaces in the DB server. I'm
> assuming you app can safely handle a failure to connect to the DB
> (i.e. exceed number of DB connections). If not it should be fairly
> simple to send a 503 header when it's unable to get the connection.
>
Note, that I am not necessarily looking for a PostgreSQL solution to the
matter. Just a way to prevent the database from killing off the server
it sits on, but looking at the load averages.
I have attempted to make use of pgpool and have had some very poor
performance. There were constant error messages being sounded, load
averages on that machine seemed to skyrocket and it just seemed to not
be suited for my needs.
Apache::DBI overall works better to what I require, even if it is not a
pool per sey. Now if pgpool supported variable rate pooling like
Apache does with it's children, it might help to even things out. That
and you'd still get the spike if you have to start the webserver and
database server at or around the same time.
Martin Foster
Creator/Designer Ethereal Realms
martin@ethereal-realms.org
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: martin@ethereal-realms.org, kevin.barnard@gmail.com
Subject: Re: Restricting Postgres
In-Reply-To: <418A5590.5090006@ethereal-realms.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