From: | "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [Re] Need help with postgresql/apache/php optimisation |
Date: | 2004-02-18 23:12:57 |
Message-ID: | 4033F179.35862535@froggycorp.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2004-02-18 23:15:34 | Re: wishlist: dynamic log volume control |
Previous Message | scott.marlowe | 2004-02-18 22:57:43 | Re: [Re] Need help with postgresql/apache/php optimisation |