Re: idle connections

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: idle connections
Дата
Msg-id dcc563d10910051751l3603440xd040b73f3b89f88a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: idle connections  (Aras Angelo <araskoktas@gmail.com>)
Список pgsql-admin
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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: idle connections
Следующее
От: Olivier Nicole
Дата:
Сообщение: postgres 8.4 authentication with LDAP