Date: Fri, 13 Oct 2006 18:29:26 +0200 From: "pobox@verysmall.org" <pobox@verysmall.org> To: freebsd-questions@freebsd.org Subject: PostgreSQL Shared Memory and Semaphors Message-ID: <452FBEE6.5010700@verysmall.org>
next in thread | raw e-mail | index | archive | help
Hello, I want to increase the max_connections of PostgreSQL from around 40 to around 100. For this I need to change the Shared Memory and Semaphores settings. I followed this link - http://www.postgresql.org/docs/8.1/interactive/kernel-resources.html#SYSVIPC and used the proposed values in a test installation FreeBSD 5.5, PostgreSQL 8.x, with 96 MB RAM (a VMware guest) - I added - kern.ipc.shmall=32768 kern.ipc.shmmax=134217728 kern.ipc.semmap=256 to /etc/sysctl.conf kern.ipc.semmni=256 kern.ipc.semmns=512 kern.ipc.semmnu=256 to /boot/loader.conf And I changed max_connections = 40 to 100 in postgresql.conf. Rebooted and all works OK. Now I want to do the same on a production machine FreeBSD 5.4, PostgreSQL 8.x, with 2 GB RAM. Are there any dangers I should have in mind? Thank you, Iv PS I know that the values can be compiled into the kernel, but I am not that good yet.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?452FBEE6.5010700>