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."
> Thanks in advance,
> Richard Ehrlich
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
In response to
pgsql-novice by date
|Next:||From: Tom Strickland||Date: 2001-03-24 12:21:56|
|Subject: Re: Configuration Parameters|
|Previous:||From: Tom Lane||Date: 2001-03-24 03:25:57|
|Subject: Re: Subselect returns too many attributes |