Re: shared_buffers > 284263 on OS X - Mailing list pgsql-performance

From Tom Lane
Subject Re: shared_buffers > 284263 on OS X
Date
Msg-id 412.1163874633@sss.pgh.pa.us
Whole thread Raw
In response to Re: shared_buffers > 284263 on OS X  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: shared_buffers > 284263 on OS X
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: start up cost estimate
Next
From: lists@event-s.net (Guido Neitzer)
Date:
Subject: Re: shared_buffers > 284263 on OS X