Re: [Re] Need help with postgresql/apache/php optimisation - Mailing list pgsql-general

From scott.marlowe
Subject Re: [Re] Need help with postgresql/apache/php optimisation
Date
Msg-id Pine.LNX.4.33.0402181556530.3855-100000@css120.ihs.com
Whole thread Raw
In response to [Re] Need help with postgresql/apache/php optimisation  ("Froggy / Froggy Corp." <froggy@froggycorp.com>)
List pgsql-general
On Wed, 18 Feb 2004, Froggy / Froggy Corp. wrote:

> Another question, i put on postgresql.conf a limited number of
> postgresql max_connections, and use permanent link beetween apache and
> postgresql. The problem is that a lot of apache thread is used for
> sending data (gfx). Is there a way to say that some thread are only here
> for php process ?

No, PHP's "connection pooling" is more of an accident looking for a place
to happen than useful sometimes.  you might want to try reverting to just
plain pg_connects and see how the machine behaves.


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Replication in postgresql
Next
From: "Froggy / Froggy Corp."
Date:
Subject: Re: [Re] Need help with postgresql/apache/php optimisation