Re: Changing the default configuration (was Re: [pgsql-advocacy]

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: PostgresSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Date: 2003-02-11T18:55:29Z
Lists: pgsql-hackers, pgsql-performance
"scott.marlowe" <scott.marlowe@ihs.com> writes:
> Is setting the max connections to something like 200 reasonable, or likely 
> to cause too many problems?

That would likely run into number-of-semaphores limitations (SEMMNI,
SEMMNS).  We do not seem to have as good documentation about changing
that as we do about changing the SHMMAX setting, so I'm not sure I want
to buy into the "it's okay to expect people to fix this before they can
start Postgres the first time" argument here.

Also, max-connections doesn't silently skew your testing: if you need
to raise it, you *will* know it.

			regards, tom lane