Thread: Configuration Parameters

Configuration Parameters

From
Richard Ehrlich
Date:
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?

Thanks in advance,
Richard Ehrlich




Re: Configuration Parameters

From
GH
Date:
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

Re: Configuration Parameters

From
Tom Strickland
Date:
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