Re: Configuration Parameters - Mailing list pgsql-novice

From Tom Strickland
Subject Re: Configuration Parameters
Date
Msg-id 20010324122156.V848@lyra.coulter
Whole thread Raw
In response to Configuration Parameters  (Richard Ehrlich <richard@techspt.com>)
List pgsql-novice
On Fri, Mar 23, 2001 at 06:00:44PM -0600, Richard Ehrlich wrote:
> I am setting up a web-based app on Apache, JServ and PostgreSQL 7.0 running
> on freeBSD. Occasionally I get a "Too many clients" exception, which I can
> work around by rebooting Apache. I understand this may be a configuration
> problem, but I am not sure how to proceed.
> If I expect about 50 concurrent full-time users, what are appropriate -N
> and -B values for the postmaster? What would be appropriate values for
> SHMMAX, SEMMNS, SEMMNI, NPROC, MAXUPRC, NFILE and NINODE? Are there any
> other configuration parameters that I need to worry about?
> What is the mechanism for shutting down postmaster instances? Should my
> Java servlets do this explicitly?

Either close the connection explicity:
connection.close();

or use connection pooling. 'Core Servlets and JavaServer Pages' has a
chapter on this.

tom

pgsql-novice by date:

Previous
From: GH
Date:
Subject: Re: Configuration Parameters
Next
From: Frank Hilliard
Date:
Subject: PostgreSQL/CF Guestbook