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 -----------------------------------------------------------------