X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 10B42475A9E for ; Tue, 11 Feb 2003 13:01:18 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 39C7C474E5C for ; Tue, 11 Feb 2003 13:01:16 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1BI1E5u026925; Tue, 11 Feb 2003 13:01:14 -0500 (EST) To: "Jon Griffin" Cc: pgsql-hackers@postgresql.org Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy] PostgreSQL Benchmarks) In-reply-to: <49391.192.168.1.12.1044985098.squirrel@mail.mayuli.com> References: <303E00EBDD07B943924382E153890E5434A909@cuthbert.rcsinc.local> <26004.1044980414@sss.pgh.pa.us> <49391.192.168.1.12.1044985098.squirrel@mail.mayuli.com> Comments: In-reply-to "Jon Griffin" message dated "Tue, 11 Feb 2003 09:38:18 -0800" Date: Tue, 11 Feb 2003 13:01:13 -0500 Message-ID: <26924.1044986473@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/403 X-Sequence-Number: 35345 "Jon Griffin" writes: > So it appears that linux at least is way above your 8 meg point, unless I > am missing something. Yeah, AFAIK all recent Linuxen are well above the range of parameters that I was suggesting (and even if they weren't, Linux is particularly easy to change the SHMMAX setting on). It's other Unixoid platforms that are likely to have a problem. Particularly the ones where you have to rebuild the kernel to change SHMMAX; people may be afraid to do that. Does anyone know whether cygwin has a setting comparable to SHMMAX, and if so what is its default value? How about the upcoming native Windows port --- any issues there? regards, tom lane