From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dave Cramer <pg@fastcrypt.com>
Cc: Brian Wipf <brian@shoptoit.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: shared_buffers > 284263 on OS X
Date: Sat, 18 Nov 2006 13:30:33 -0500
Message-ID: <412.1163874633@sss.pgh.pa.us> (raw)
In-Reply-To: <82E59D2F-0946-4405-8F11-4CF5184A9399@fastcrypt.com>
References: <B242A585-E94C-4ECA-8FA9-DCE72E1D8838@shoptoit.ca>
<82E59D2F-0946-4405-8F11-4CF5184A9399@fastcrypt.com>
Dave Cramer <pg@fastcrypt.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, pg@fastcrypt.com, brian@shoptoit.ca
Subject: Re: shared_buffers > 284263 on OS X
In-Reply-To: <412.1163874633@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox