Thread: Configuration Parameters

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

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

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