Re: PHP + Postgres: More than 1000 postmasters produce

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.