Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0F8529F9FB1 for ; Sat, 18 Nov 2006 14:30:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 42071-06 for ; Sat, 18 Nov 2006 18:30:37 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F34109F9B3F for ; Sat, 18 Nov 2006 14:30:36 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kAIIUXbU000413; Sat, 18 Nov 2006 13:30:33 -0500 (EST) To: Dave Cramer cc: Brian Wipf , pgsql-performance@postgresql.org Subject: Re: shared_buffers > 284263 on OS X In-reply-to: <82E59D2F-0946-4405-8F11-4CF5184A9399@fastcrypt.com> References: <82E59D2F-0946-4405-8F11-4CF5184A9399@fastcrypt.com> Comments: In-reply-to Dave Cramer message dated "Sat, 18 Nov 2006 11:17:01 -0500" Date: Sat, 18 Nov 2006 13:30:33 -0500 Message-ID: <412.1163874633@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/149 X-Sequence-Number: 21919 Dave Cramer writes: > On 16-Nov-06, at 7:03 PM, Brian Wipf wrote: >> Has anyone else noticed this limitation on OS X? Any ideas on how I >> might get shared_buffers higher than 284263? > My guess is something else has taken shared memory ahead of you. OS X > seems to be somewhat strange in how it deals with shared memory. Try > allocating more to shmmax ? Look in "ipcs -m -a" output to check this theory. (I am glad to see that ipcs and ipcrm are finally there in recent OS X releases --- awhile back they were not, leaving people to fly entirely blind while dealing with issues like this :-() regards, tom lane