MacOS X Shared Buffers (SHMMAX)? - Mailing list pgsql-general

From Command Prompt, Inc.
Subject MacOS X Shared Buffers (SHMMAX)?
Date
Msg-id Pine.LNX.4.30.0205201919440.902-100000@commandprompt.com
Whole thread Raw
In response to Re: Performance issues with compaq server  (Holger Marzen <holger@marzen.de>)
Responses Re: MacOS X Shared Buffers (SHMMAX)?
Re: MacOS X Shared Buffers (SHMMAX)?
List pgsql-general
Good day,

Does anyone have any experience in increasing the amount of shared memory
buffers available to Mac OS X/Darwin? When starting with more than 128
backend connections on a test G3 I encounter:

-----------------------------------------------------------------------------------
IpcMemoryCreate: shmget(key=5432001, size=33357824, 03600) failed: Invalid argument

This error usually means that PostgreSQL's request for a shared memory
segment exceeded your kernel's SHMMAX parameter.  You can either
reduce the request size or reconfigure the kernel with larger SHMMAX.
-----------------------------------------------------------------------------------

However, I can find no helpful information looking around for how Darwin
handles this configuration. Hopefully it does not require a recompile of
the Kernel. ;)

Any knowledge on this topic would be greatly appreciated.

Best Regards,
Jw.
--
jlx@commandprompt.com
by way of pgsql-general@commandprompt.com
http://www.postgresql.info/
http://www.commandprompt.com/


pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Help..
Next
From: Dan Weston
Date:
Subject: Added index ability for isbn-issn contrib example