connection pool

From: "Peter Hofer" <peter(dot)hofer(at)ics(dot)at>
To: <pgsql-php(at)postgresql(dot)org>
Subject: connection pool
Date: 2006-07-31 19:48:38
Message-ID: 008d01c6b4da$5143b5e0$6515a8c0@ics2003.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Hervé Piedvache 2006-08-01 07:29:00 Re: connection pool
Previous Message George Weaver 2006-07-31 16:16:42 Re: Triggers using PL/pgSQL