Re: Increasing Shared Memory - on MacOS X

From: Chris Ruprecht <chrup999(at)yahoo(dot)com>
To: PostGreSQL Admin Group <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Increasing Shared Memory - on MacOS X
Date: 2002-01-25 01:39:50
Message-ID: p05101200b87665f84a41@[192.168.0.6]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

At 14:21 -0500 01/24/2002, Zhang, Anna wrote:
>You need to increase SHMMAX. For solaris, it's in /etc/system file; Linux:
>/etc/sysctl.conf. You should know corresponding file for your system or
>check with your SA to figure out.

I have this well under control on my production server (Linux) with
/sbin/sysctl. I am doing development on a PowerBook G4 running MacOS
X 10.1.2 and I have tried to up the shared memory on the
postgres.conf file. I have it at 256 8K blocks and it's working, but
it's pretty slow. When I try and specify more memory (512 8K Blocks
or more), I get an error, telling me that the system is not allowing
more.
I can not ask my SA, I AM the SA ;-). And there are no recognizable
files in or around the /etc directory, I can modify. MacOS X has the
sysctl command, but there is no kern.shmmax parameter to read or set.
This is a MacOS X SPECIFIC question, and solutions for other UNIXen
don't quite apply.
I checked on the web and any other available resource on this, but
came up empty handed ...

Best regards,
Chris
--
Chris Ruprecht
Network grunt and bit pusher extraordinaíre

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-01-25 02:06:20 Re: Increasing Shared Memory - on MacOS X
Previous Message David Stanaway 2002-01-24 23:41:31 Re: What erd tool supports pgsql??/