Limit on Number of connections

From: "Bryan White" <bryan(at)arcamax(dot)com>
To: <pgsql-admin(at)postgreSQL(dot)org>
Subject: Limit on Number of connections
Date: 1998-11-11 15:56:28
Message-ID: 009b01be0d8b$d7a850e0$a3f0f6ce@bryan.arcamax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

What is the maximum number of simultaneous connections to postgres. The
mysql site comparisons indicate it is 36. I have seen references in this
list that the limit can be set when the server backend is compiled. If so,
where? What is the downside of setting it too high? Is 100..200
unreasonable. This will be on a machine with 256MB of ram doing postgres
and maybe some web serving.

Is there a way to monitor the status of the server (active connections, busy
connections, etc...)?

Is it generally better to have an Apache module accessing the database on
the local machine on on another box on the sub-net. I guessing the ultimate
would be a dedicated 100MB ethernet connection from the web server to the
database server, but maybe its better to just put them both on the same box.

Bryan White
ArcaMax Inc.
Yorktown VA
www.arcamax.com

Browse pgsql-admin by date

  From Date Subject
Next Message Joerg Schultz 1998-11-12 15:24:28 StreamServerPort: bind() failed
Previous Message Henrik Bo Thystrup 1998-11-11 13:12:57 Error compiling libpq++ under AIX