connection pool

"Peter Hofer" <peter.hofer@xxxxxx> · Mon, 31 Jul 2006 21:48:38 +0200

Hallo 

Need your help 

1 got a Site runnig php 4.4.2 and postgresql (8.1.4) and 
Follwing problem 

- 4 Server (Apache) up to 300 clients connection to the DB 
- 1 DB machine 

So: 

- If I run with persisent, i got up to 1200 Connction and I run out 
  of memeory

- if I run with no persisent connection i got massive forking of postgres 
  (but less problems) 

How can I build up a Pool of Connections ? 

What about "Pgpool" ? 

Thanks 