pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedIssues with OSX and SHMMAX?
5+ messages / 4 participants
[nested] [flat]
* Issues with OSX and SHMMAX?
@ 2013-04-21 21:29 Josh Berkus <josh@agliodbs.com>
2013-04-21 21:33 ` Re: Issues with OSX and SHMMAX? Evgeny Shishkin <itparanoia@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Josh Berkus @ 2013-04-21 21:29 UTC (permalink / raw)
To: pgsql-performance
Folks,
I've heard a rumor that the most recent update of OSX "mountain lion"
lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from
installing. Can anyone verify this?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Issues with OSX and SHMMAX?
2013-04-21 21:29 Issues with OSX and SHMMAX? Josh Berkus <josh@agliodbs.com>
@ 2013-04-21 21:33 ` Evgeny Shishkin <itparanoia@gmail.com>
2013-04-22 18:19 ` Re: Issues with OSX and SHMMAX? Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 5+ messages in thread
From: Evgeny Shishkin @ 2013-04-21 21:33 UTC (permalink / raw)
To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance
On Apr 22, 2013, at 1:29 AM, Josh Berkus <josh@agliodbs.com> wrote:
> Folks,
>
> I've heard a rumor that the most recent update of OSX "mountain lion"
> lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from
> installing. Can anyone verify this?
>
kern.sysv.shmmax: 4194304
mac os x 10.8.3
> --
> Josh Berkus
> PostgreSQL Experts Inc.
> http://pgexperts.com.
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Issues with OSX and SHMMAX?
2013-04-21 21:29 Issues with OSX and SHMMAX? Josh Berkus <josh@agliodbs.com>
2013-04-21 21:33 ` Re: Issues with OSX and SHMMAX? Evgeny Shishkin <itparanoia@gmail.com>
@ 2013-04-22 18:19 ` Josh Berkus <josh@agliodbs.com>
2013-04-22 22:30 ` Re: Issues with OSX and SHMMAX? Steve Atkins <steve@blighty.com>
0 siblings, 1 reply; 5+ messages in thread
From: Josh Berkus @ 2013-04-22 18:19 UTC (permalink / raw)
To: pgsql-performance
On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
>
> On Apr 22, 2013, at 1:29 AM, Josh Berkus <josh@agliodbs.com> wrote:
>
>> Folks,
>>
>> I've heard a rumor that the most recent update of OSX "mountain lion"
>> lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from
>> installing. Can anyone verify this?
>>
>
> kern.sysv.shmmax: 4194304
That would be 4MB. Can anyone else verify this?
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Issues with OSX and SHMMAX?
2013-04-21 21:29 Issues with OSX and SHMMAX? Josh Berkus <josh@agliodbs.com>
2013-04-21 21:33 ` Re: Issues with OSX and SHMMAX? Evgeny Shishkin <itparanoia@gmail.com>
2013-04-22 18:19 ` Re: Issues with OSX and SHMMAX? Josh Berkus <josh@agliodbs.com>
@ 2013-04-22 22:30 ` Steve Atkins <steve@blighty.com>
2013-04-23 00:39 ` Re: Issues with OSX and SHMMAX? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: Steve Atkins @ 2013-04-22 22:30 UTC (permalink / raw)
To: pgsql-performance
On Apr 22, 2013, at 11:19 AM, Josh Berkus <josh@agliodbs.com> wrote:
> On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
>>
>> On Apr 22, 2013, at 1:29 AM, Josh Berkus <josh@agliodbs.com> wrote:
>>
>>> Folks,
>>>
>>> I've heard a rumor that the most recent update of OSX "mountain lion"
>>> lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from
>>> installing. Can anyone verify this?
>>>
>>
>> kern.sysv.shmmax: 4194304
>
> That would be 4MB. Can anyone else verify this?
It's the default setting on my 10.8.3 box. (I'm setting it higher in /etc/sysctl.conf
and have no problems, but it stopped postgres.app starting when I removed
that).
Cheers,
Steve
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Issues with OSX and SHMMAX?
2013-04-21 21:29 Issues with OSX and SHMMAX? Josh Berkus <josh@agliodbs.com>
2013-04-21 21:33 ` Re: Issues with OSX and SHMMAX? Evgeny Shishkin <itparanoia@gmail.com>
2013-04-22 18:19 ` Re: Issues with OSX and SHMMAX? Josh Berkus <josh@agliodbs.com>
2013-04-22 22:30 ` Re: Issues with OSX and SHMMAX? Steve Atkins <steve@blighty.com>
@ 2013-04-23 00:39 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2013-04-23 00:39 UTC (permalink / raw)
To: Steve Atkins <steve@blighty.com>; Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance
Steve Atkins <steve@blighty.com> writes:
> On Apr 22, 2013, at 11:19 AM, Josh Berkus <josh@agliodbs.com> wrote:
>> On 04/21/2013 02:33 PM, Evgeny Shishkin wrote:
>>> On Apr 22, 2013, at 1:29 AM, Josh Berkus <josh@agliodbs.com> wrote:
>>>> I've heard a rumor that the most recent update of OSX "mountain lion"
>>>> lowers the installed SHMMAX to 4MB, which prevents PostgreSQL from
>>>> installing. Can anyone verify this?
>>> kern.sysv.shmmax: 4194304
>> That would be 4MB. Can anyone else verify this?
> It's the default setting on my 10.8.3 box. (I'm setting it higher in
> /etc/sysctl.conf and have no problems, but it stopped postgres.app
> starting when I removed that).
AFAIR, the default setting has been that or lower in every previous
version of OSX, so it seems unlikely that mountain lion per se broke
anything. It might've appeared that way if you did a reinstall and
forgot to copy your old /etc/sysctl.conf.
A different theory, if things used to work and now don't, is that
somewhere recently we crossed a threshold in memory usage between
"will start at 4MB" and "won't start at 4MB". If so, 9.3 ought to
make things better (since we're mostly getting out from under SysV
shared memory limits), but in existing releases manually fixing
the limit will be the only recourse.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2013-04-23 00:39 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-04-21 21:29 Issues with OSX and SHMMAX? Josh Berkus <josh@agliodbs.com>
2013-04-21 21:33 ` Evgeny Shishkin <itparanoia@gmail.com>
2013-04-22 18:19 ` Josh Berkus <josh@agliodbs.com>
2013-04-22 22:30 ` Steve Atkins <steve@blighty.com>
2013-04-23 00:39 ` Tom Lane <tgl@sss.pgh.pa.us>
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