Joe Lester <[EMAIL PROTECTED]> writes:I installed Postgres 7.4.1 on a dual processor G5 running Mac OS 10.3.2. I'm trying to increase the max_connections to 300 and running into some trouble.
Hmm, it WorksForMe (TM). You did reboot after changing /etc/rc, no?
Yes, I did a "Restart".
Try "sysctl -a | grep sysv" to verify that the settings took effect.
That's odd. It's giving me a -1 for the shmmax value. I assume that's NOT normal. Why would that be?
[lester2:~] joe% sysctl -a | grep sysv kern.sysv.shmmax: -1 kern.sysv.shmmin: 1 kern.sysv.shmmni: 32 kern.sysv.shmseg: 8 kern.sysv.shmall: 50772160 kern.sysv.semmni: 87381 kern.sysv.semmns: 87381 kern.sysv.semmnu: 87381 kern.sysv.semmsl: 87381 kern.sysv.semume: 10
Note that there's not much percentage in setting shmmax higher than shmall * pagesize. I see hw.pagesize = 4096 according to sysctl, which means your shmall=65536 constrains the total allocation to 256MB, so setting shmmax to 500M doesn't do anything...
I'm not quite clear on this. Does this mean that shmmax and shmall should be set to the same value? Could anyone share with me their own settings for shmmax and shmall?
Thanks.
---------------------------(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
