Jim,
I didn't understand your comment
"It appears that you can shrink shmmax but not expand
it."
I did not comment out the kern.sysv.shmmax line and
it appears that my larger setting is sticking. Or is
it? What is that command to return the currrnt values
from the terminal?
Ted
--- "Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> That's interesting. On my powerbook, I had to
> comment out the sysctl -w
> kern.sysv.shmmax line in /etc/rc. It appears that
> you can shrink shmmax
> but not expand it. This meant that it would properly
> set it based on
> /etc/syscttl.conf, but that (large) setting would
> then be over-written
> by the subsiquent sysctl -w.
>
> On Fri, Apr 29, 2005 at 09:39:55AM -0700, Theodore
> Petrosky wrote:
> > I just updated to 10.3.9 and of course the /etc/rc
> was
> > dinged. I opened the /etc/rc and found a change..
> >
> > # System tuning
> > sysctl -w kern.maxvnodes=$(echo $(sysctl -n
> > hw.physmem) '33554432 / 512 * 1024 +p'|dc)
> > if [ -f /etc/sysctl-macosxserver.conf ]; then
> > awk '{ if (!index($1, "#") && index($1,
> "="))
> > print $1 }' < /etc/sysctl-macosxserver.conf |
> while
> > read
> > do
> > sysctl -w ${REPLY}
> > done
> > fi
> >
> > if [ -f /etc/sysctl.conf ]; then
> > awk '{ if (!index($1, "#") && index($1,
> "="))
> > print $1 }' < /etc/sysctl.conf | while read
> > do
> > sysctl -w ${REPLY}
> > done
> > fi
> >
> > sysctl -w kern.sysv.shmmax=4194304
> > sysctl -w kern.sysv.shmmin=1
> > sysctl -w kern.sysv.shmmni=32
> > sysctl -w kern.sysv.shmseg=8
> > sysctl -w kern.sysv.shmall=1024
> >
> > It appears that apple is checking for
> etc/sysctl.conf
> > before setting the sysctl values. so I created a
> > etc/sysctl.conf with this inside:
> >
> > kern.sysv.shmmax=33554432
> > kern.sysv.shmmin=1
> > kern.sysv.shmmni=32
> > kern.sysv.shmseg=8
> > kern.sysv.shmall=65536
> >
> > I did not alter /etc/rc. postgresql starts up just
> > fine. I hope this implys that the issue is
> resolved..
> >
> > Ted
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> [EMAIL PROTECTED]
> >
>
> --
> Jim C. Nasby, Database Consultant
> [EMAIL PROTECTED]
> Give your computer some brain candy!
> www.distributed.net Team #1828
>
> Windows: "Where do you want to go today?"
> Linux: "Where do you want to go tomorrow?"
> FreeBSD: "Are you guys coming, or what?"
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
