On Mar 22, 2006, at 6:01 AM, Kipp Holger wrote:

which are set correctly. Unfortunately, the following
two entries

  kern.ipc.shmmax="512000000"
  kern.ipc.shmall="65526"

do not change the corresponding values according
to sysctl, no matter whether I put them in
/boot/loader.conf or /etc/sysctl.conf.

Here is how I bump up values to run a large-ish postgresql server under 6.0-p4:

in /boot/loader.conf I have

kern.ipc.semmni=32
kern.ipc.semmns=512


and in /etc/sysctl.conf I have

# tuning for PostgreSQL
kern.ipc.shm_use_phys=1
kern.ipc.shmmax=1073741824
kern.ipc.shmall=262144
kern.ipc.semmsl=512
kern.ipc.semmap=256


and it works just fine.  IIRC it worked the same in 5.4.

_______________________________________________
freebsd-stable@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-stable
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to