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

From Froggy / Froggy Corp.
Subject Re: [Re] Need help with postgresql/apache/php optimisation
Date
Msg-id 4033F179.35862535@froggycorp.com
Whole thread Raw
In response to Re: [Re] Need help with postgresql/apache/php optimisation  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
In fact, under php4.?, the connexion is not save under session, so i
allways need to make a pg_connect. But under documentation it say that
the socket stay open, so i save some cpu.

"scott.marlowe" wrote:
>
> 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: "scott.marlowe"
Date:
Subject: Re: [Re] Need help with postgresql/apache/php optimisation
Next
From: Martijn van Oosterhout
Date:
Subject: Re: wishlist: dynamic log volume control