Re: 100 simultaneous connections, critical limit?

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: 100 simultaneous connections, critical limit?
Date: 2004-01-14 13:01:00
Message-ID: 200401141831.00453.shridhar_daithankar@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wednesday 14 January 2004 18:18, Jón Ragnarsson wrote:
> I am writing a website that will probably have some traffic.
> Right now I wrap every .php page in pg_connect() and pg_close().
> Then I read somewhere that Postgres only supports 100 simultaneous
> connections (default). Is that a limitation? Should I use some other
> method when writing code for high-traffic website?

Yes. You should rather investigate connection pooling.

I am no php expert but probably this could help you..

http://www.php.net/manual/en/function.pg-pconnect.php

Shridhar

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2004-01-14 13:27:03 Re: 100 simultaneous connections, critical limit?
Previous Message Jón Ragnarsson 2004-01-14 12:48:17 100 simultaneous connections, critical limit?