Re: Apache + PHP + Postgres Interaction

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Apache + PHP + Postgres Interaction
Date: 2007-08-24 07:20:52
Message-ID: fam0sd$1q3l$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 24.08.2007 02:43, Bill Moran wrote:
>> Hannes Dorbath <light(at)theendofthetunnel(dot)de> wrote:
>>> Bill Moran wrote:
>>>> I guess I just feel that "broken" is a bit of a harsh term. If
>>>> your expectations are for full-blown connection management from
>>>> pconnect(), then you will be disappointed. If you take it for
>>>> what it is: persistent connections, then those limitations would
>>>> be expected.
>>> It's broken because persistent connections get randomly garbage
>>> collected where they should not. So broken in the sense of bugged.
>>> Expect connections to die for no reason, especially under load.
>>
>> It's funny that you should mention that, since I haven't seen that
>> behaviour in 18 months of load testing over a dozen servers.

Please reply to the list as well.

How did you verify that? It will spawn a new connection silently, if the
old got dropped. Did you really verify your logs, that you don't get
more new connections than Apache spawns workers? This might not be
noticeable for you, if you are running Apache. In a FCGI environment
where you have a fixed amount of workers, you notice new connections, as
there should not be any.

--
Regards,
Hannes Dorbath

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-08-24 07:57:41 Re: Undetected corruption of table files
Previous Message Hannes Dorbath 2007-08-24 07:17:47 Re: Apache + PHP + Postgres Interaction