Re: [Re] Need help with postgresql/apache/php optimisation

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.

In response to

Browse pgsql-general by date

  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