Re: Website troubles - Mailing list pgsql-general

From scott.marlowe
Subject Re: Website troubles
Date
Msg-id Pine.LNX.4.33.0301301216560.22730-100000@css120.ihs.com
Whole thread Raw
In response to Re: Website troubles  ("Marc G. Fournier" <scrappy@hub.org>)
List pgsql-general
On Wed, 29 Jan 2003, Marc G. Fournier wrote:

> On Wed, 29 Jan 2003, Robert Treat wrote:
>
> > Well, maybe it does, but when an important news story drives new
> > eyeballs to your website, you need something better than a bouncing $hit
> > happens logo if you want to make a positive impression. All Greg wants
> > to know is what caused the problem and what steps are being taken to
> > make sure it doesn't happen again. That's hardly unreasonable.
>
> The problem is/was persistent database connections ... the problem, IMHO,
> is that there is no way of 'timing out' idle connections, so any load on
> the web site that creates a whack of persistent connections, and then they
> all go idle, then if another hit on a different database goes through, it
> gets starved for connections ...
>
> I've started to disable PHPs default of allowing persistent connections,
> which seems to have help'd ...

I've posted on this before once or twice.  Basically, whatever Apache's
max children is set to, postgresql to be set for a higher number of
connections.  since apache defaults to a much higher number, it's a
problem looking to happen.

If you drop the max apache children to say 64 and crank the max
connections on pgsql to 128 or so, it'll work fine.


pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: pgsql.com problem.
Next
From: Greg Copeland
Date:
Subject: Re: serialization errors