| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | "Gellert, Andre" <AGellert(at)ElectronicPartner(dot)de>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PHP + Postgres: More than 1000 postmasters produce |
| Date: | 2004-02-20 17:57:41 |
| Message-ID: | Pine.LNX.4.33.0402201054100.10445-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gellert, Andre | 2004-02-20 17:58:31 | Re: PHP + Postgres: More than 1000 postmasters produce |
| Previous Message | tibor | 2004-02-20 17:22:36 | Re: How can I delete a primary or foreign key? |