Number of connections to postgres

From: "Vaibhav Puranik" <vpuranik(at)tietronix(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Number of connections to postgres
Date: 2003-02-26 22:23:07
Message-ID: b3jeo9$1l1l$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi friends,

I am using Redhat Linux 8 with Postgres 7.3.1
I am running jboss server on the same machine. Right now my postgres uses
default number of connections which is 32.
I am planning to deploy some more web applications of the same server. This
will necessitate me to increase max number of connections to postgres.

Can anybody guide me on what is the typical number of connections for an web
application that can get about 500 requests simulteneously. If I set my max
number of connections to 100 do I need to change shmmax which is now set to
32 MB?

Regards,
Vaibhav Puranik

Browse pgsql-general by date

  From Date Subject
Next Message Carlos Moreno 2003-02-26 22:56:27 Still intrigued... (was: Socket command type e unknown)
Previous Message Stephan Szabo 2003-02-26 22:17:36 Re: index usage (and foreign keys/triggers)