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