pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (34+ messages)  latest in thread

Message-ID: <418A5590.5090006@ethereal-realms.org>
Permalink:  ../418A5590.5090006@ethereal-realms.org/
Also on:    postgresql.org/message-id/418A5590.5090006@ethereal-realms.org

 · 

reply

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