Re: [HACKERS] Re: PHPBuilder article -- Postgres vs MySQL

Martin A. Marques <martin@math.unl.edu.ar>

From: "Martin A. Marques" <martin@math.unl.edu.ar>
To: Marko Kreen <marko@l-t.ee>, The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-general@postgresql.org
Date: 2000-11-17T19:08:26Z
Lists: pgsql-hackers
On Jue 16 Nov 2000 22:54, Marko Kreen wrote:
> On Thu, Nov 16, 2000 at 01:33:08PM -0400, The Hermit Hacker wrote:
> >
> > I run PHP4 and IMP (http://www.horde.org) and we've gotten then to remove
> > the useof pg_pconnect() since it is broken.  Broken how, you might
> > ask?  Well, I ran on a standalone machine, no other web users but myself,
> > to test, and each tim eI hit the database with IMP,. it opened a new
> > backend, but it never reused old, idle ones ... eventually, you run out
> > of the ability to connect since you've locked up all connections ...
>
> Maybe you have the apache maxspareservers set too high?  I run
> PHP4/apache (debian-woody) and it works ok.  If this is only IMP
> site maybe you are better off
>
>   apache.MaxClients = postgres.backendcount

What I can say on my behave is that (as the only user of PHP and Postgres on 
the computer) when I login to IMP webmail, quite a lot of postmasters appear, 
and don't dissapear after logging off.
but I have no problem. I can be all day with IMP fooling around and the 
backend postmaster would stay around the 20 live conections.

Any comments?

Saludos.. :-)


-- 
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Martn Marqus			email: 	martin@math.unl.edu.ar
Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------