X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9559E474E5C for ; Tue, 11 Feb 2003 14:16:47 -0500 (EST) Received: from CopelandConsulting.Net (dsl-24293-ld.customer.centurytel.net [209.142.135.135]) by postgresql.org (Postfix) with ESMTP id A7EE0474E53 for ; Tue, 11 Feb 2003 14:16:46 -0500 (EST) Received: from [192.168.1.2] (mouse.copelandconsulting.net [192.168.1.2]) by CopelandConsulting.Net (8.10.1/8.10.1) with ESMTP id h1BJG9703263; Tue, 11 Feb 2003 13:16:09 -0600 (CST) X-Trade-Id: To: Tom Lane Cc: "scott.marlowe" , PostgresSQL Hackers Mailing List In-Reply-To: <27232.1044989729@sss.pgh.pa.us> References: <27232.1044989729@sss.pgh.pa.us> Content-Type: text/plain Organization: Copeland Computer Consulting Message-Id: <1044990974.2501.207.camel@mouse.copelandconsulting.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.0 Date: 11 Feb 2003 13:16:15 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/414 X-Sequence-Number: 35356 On Tue, 2003-02-11 at 12:55, Tom Lane wrote: > "scott.marlowe" 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. > Besides, I'm not sure that it makes sense to let other product needs dictate the default configurations for this one. It would be one thing if the vast majority of people only used PostgreSQL with Apache. I know I'm using it in environments in which no way relate to the web. I'm thinking I'm not alone. Regards, -- Greg Copeland Copeland Computer Consulting