Re: PHP + Postgres: More than 1000 postmasters produce

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: PHP + Postgres: More than 1000 postmasters produce
Дата
Msg-id Pine.LNX.4.33.0402201054100.10445-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: PHP + Postgres: More than 1000 postmasters produce  (Csaba Nagy <nagy@ecircle-ag.com>)
Список pgsql-general
On 20 Feb 2004, Csaba Nagy wrote:

> Well, it seems for your application is better to limit php's persistent
> connection pool as a quick measure.
> Try to set these values to something sensible for you:
>
> ; Maximum number of persistent links.  -1 means no limit.
> pgsql.max_persistent = 20

Please note that pgsql.max_persistant is PER apache / php backend process.

http://www.php.net/manual/en/ref.pgsql.php
QUOTE:
pgsql.max_persistent  integer

    The maximum number of persistent Postgres connections per process.
UNQUOTE:

> ; Maximum number of links (persistent+non persistent).  -1 means no limit.
> pgsql.max_links = 30

This one too is per process

> Or just disable persistent connections altogether, and see if that is
> not resulting in better performance:

My recommendation.



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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: PHP + Postgres: More than 1000 postmasters produce
Следующее
От: "Gellert, Andre"
Дата:
Сообщение: Re: PHP + Postgres: More than 1000 postmasters produce