Re: Configuration Parameters - Mailing list pgsql-novice

From GH
Subject Re: Configuration Parameters
Date
Msg-id 20010323221721.A53444@over-yonder.net
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, some SMTP stream spewed forth:
> 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?

I believe the answer is "yes", but I am not certain.
If nothing else, it seems like it would be better to close explicitly the
connections, so that you "know."

dan

>
> Thanks in advance,
> Richard Ehrlich
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Subselect returns too many attributes
Next
From: Tom Strickland
Date:
Subject: Re: Configuration Parameters