From: Tom Lane <tgl@sss.pgh.pa.us>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Gavin Kistner <phrogz@mac.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Fresh build on OS X not working (memory)
Date: Sat, 01 May 2010 22:54:17 -0400
Message-ID: <29663.1272768857@sss.pgh.pa.us> (raw)
In-Reply-To: <z2ndcc563d11005011928kf9373bfcu1c1a80e040671fbe@mail.gmail.com>
References: <88181C2E-01CD-417C-8266-D5C9AF570C27@mac.com>
<15253.1272606140@sss.pgh.pa.us>
<z2ndcc563d11005011928kf9373bfcu1c1a80e040671fbe@mail.gmail.com>
Scott Marlowe <scott.marlowe@gmail.com> writes:
> On Thu, Apr 29, 2010 at 11:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> OSX is *notoriously* unfriendly about configuring shm parameters.
>> You look at it sidewise, it doesn't work, and generally won't tell
>> you why it's refusing to talk to you. We document a few of the known
>> constraints in our manual, but I'm sure there are more.
> The fact that they seem to change the needed magical incantations
> every point release doesn't help things either.
Actually, it appears they've finally reached a point of reasonable
sanity in 10.6. It's still true that they reject non-page-multiple
SHMMAX, instead of rounding to the next page boundary like everybody
else does; but the old kluges whereby you could only set the values by
waving a dead chicken in a specific fashion during boot seem to be
mostly gone. I wasn't aware of this myself, not having experimented
recently.
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, scott.marlowe@gmail.com, phrogz@mac.com
Subject: Re: Fresh build on OS X not working (memory)
In-Reply-To: <29663.1272768857@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