Re: Persistent Connects (pg_pconnect) - Mailing list pgsql-sql

From Serge Canizares
Subject Re: Persistent Connects (pg_pconnect)
Date
Msg-id 3A1BD36F.68722F03@ephilosopher.com
Whole thread Raw
In response to Persistent Connects (pg_pconnect)  (Colleen Williams <colleen@digital-arts.co.uk>)
List pgsql-sql
> Not sure if this is related, but under the non-threading Apache
> server, you get 1 persistent connection per Apache process.  I don't
> think you can be sure which process gets the page with the connection
> request, so if you have a limit of, say, 50 processes, and your server
> is hit fairly often, eventually you'll see 50 connections even though
> only a few simultaneous accesses to PHP/PostgreSQL are made.
>
> Or, I could be totally off.
>
> -itai

Actually, with php 4.0x, the apache processes can gather a pool of persistent connexions.

I had the same sort of problem once, and saw that each apache process was grabbing ~4
postgreSQL connexions and thus maxing out the number available from the server.



pgsql-sql by date:

Previous
From:
Date:
Subject: special caracters??
Next
From: Roberto Mello
Date:
Subject: Re: Persistent Connects (pg_pconnect)