Re: too many clients - Mailing list pgsql-php

From Greg Stark
Subject Re: too many clients
Date
Msg-id 87y8fg8iqi.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: too many clients  ("Gavin M. Roy" <gmr@ehpg.net>)
Responses Re: too many clients  ("Gavin M. Roy" <gmr@ehpg.net>)
List pgsql-php
"Gavin M. Roy" <gmr@ehpg.net> writes:

> I use it on a few very high traffic sites without issue, but it is tuned so
> that there is only 1 persistant connection per apache backend and postgresql
> will allow the max apache backends, which by default is generally 256. I
> highly recommend it in such a situation, while I generally do not recommend
> it in any other.

That doesn't sound reasonable. Does your machine really have so many
processors or i/o bandwidth that 256 postgres processes can really all make
progress?

Or do you have images and static html on the same web server? If so I suggest
moving them to another web server. No need to have a postgres instance (and a
php instance) sitting idle consuming memory waiting until someone happens to
hit a dynamic page.

--
greg

pgsql-php by date:

Previous
From: "Gavin M. Roy"
Date:
Subject: Re: too many clients
Next
From: "Gavin M. Roy"
Date:
Subject: Re: too many clients