Re: shared_buffers > 284263 on OS X

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: Brian Wipf <brian(at)shoptoit(dot)ca>, pgsql-performance(at)postgresql(dot)org
Subject: Re: shared_buffers > 284263 on OS X
Date: 2006-11-18 18:30:33
Message-ID: 412.1163874633@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dave Cramer <pg(at)fastcrypt(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guido Neitzer 2006-11-18 18:44:39 Re: shared_buffers > 284263 on OS X
Previous Message Tom Lane 2006-11-18 18:11:08 Re: start up cost estimate