Re: idle connections

On Mon, Oct 5, 2009 at 5:50 PM, Aras Angelo <araskoktas@gmail.com> wrote:
> Its a regular pg_connect()
>
> When i kill the earliest idle process the others stop too. So i dont know
> whats wrong really. All our apps use the same footer, with pg_close() at the
> end.
>
> I have done most of the things you guys suggested, so it seems to me that
> something between php-apache-postgresql is not doing good, and it only
> effects us at peak times, so just wondering if killing processes every 2-3
> minutes, would do harm on our setup.
>
> I have 3 apache servers reading from one single db server.

So what's your max apache children / threads and what's your max pgsql
connections allowed?  You may need to crank up pgsql connection limit
to keep up.