Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres
Date: 2009-07-04 15:22:16
Message-ID: 4A4F73A8.1090008@Sheeky.Biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tom Lane wrote:
> Shane Ambler <pgsql(at)Sheeky(dot)Biz> writes:
>> Also of note - you are setting the shmmax to 4GB which is all of your
>> ram to shared memory. A bit extreme even if it was a postgres only
>> dedicated server.
>
> I have some recollection that OSX treats that as a 32bit number, which
> means you *can't* set it >= 4GB. Try 1GB or 2GB just to get it working.
>
> regards, tom lane
>

Could be - not a fully 64 bit clean kernel yet?
Maybe that will change with 10.6 - suppose to be a full 64 bit system,
right?

Although does it allow you to allocate 100% or more of physical ram to
shared mem?

--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message richard terry 2009-07-05 00:20:06 Are views created 'on the fly'
Previous Message Shane Ambler 2009-07-04 15:13:19 Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres