configure shmmax on MAC OS X

From: Qing Zhao <qzhao(at)quotefx(dot)net>
To: 'Postgresql Performance' <pgsql-performance(at)postgresql(dot)org>
Cc: Qing Zhao <qzhao(at)quotefx(dot)net>
Subject: configure shmmax on MAC OS X
Date: 2004-04-13 18:49:43
Message-ID: 53A6FF52-8D7B-11D8-92CF-000A95AB8896@quotefx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Hi, all,

I have got a new MaC OS G5 with 8GB RAM. So i tried to increase
the shmmax in Kernel so that I can take advantage of the RAM.

I searched the web and read the manual for PG7.4 chapter 16.5.1.
After that, I edited /etc/rc file:

sysctl -w kern.sysv.shmmax=4294967296 // byte
sysctl -w kern.sysv.shmmin=1
sysctl -w kern.sysv.shmmni=32
sysctl -w kern.sysv.shmseg=8
sysctl -w kern.sysv.shmall=1048576 //4kpage

for 4G shared RAM.

Then I changed postgresql.conf:
shared_buffer=100000 //could be bigger?

and restart the machine and postgres server. To my surprise, postgres
server wouldn't
start, saying that the requested shared memory exceeds kernel's shmmax.

My suspision is that the change i made in /etc/rc does not take
effect.Is there a way
to check it? Is there an
up limit for how much RAM can be allocated for shared buffer in MAC OS
X? Or
is there something wrong with my calculation in numbers?

Thanks a lot!

Qing

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-04-13 19:18:42 Re: query slows down with more accurate stats
Previous Message Robert Treat 2004-04-13 18:35:16 Re: index v. seqscan for certain values