Date: Wed, 24 May 2006 10:11:52 -0400 From: Vivek Khera <vivek@khera.org> To: FreeBSD Stable <freebsd-stable@freebsd.org> Subject: Re: PostgreSQL uses more memory on 6.1? Message-ID: <42A89ED6-54B7-43EC-832B-A54F76C0D17B@khera.org> In-Reply-To: <200605231531.18092.kirk@strauser.com> References: <200605231531.18092.kirk@strauser.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--Apple-Mail-3-521504846 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On May 23, 2006, at 4:31 PM, Kirk Strauser wrote: > Has anyone else seen this behavior when upgrading from 6.0 to 6.1? > Any > ideas for a fix? > no. not seen it. did you have a custom kernel with higher SHM settings on 6.0? In any case, here is what you do: in /etc/sysctl.conf add these: kern.ipc.shm_use_phys=1 kern.ipc.shmmax=1073741824 kern.ipc.shmall=262144 kern.ipc.semmsl=512 kern.ipc.semmap=256 and in /boot/loader.conf add these: kern.ipc.semmni=32 kern.ipc.semmns=512 the "sem" variables are really only needed if you want a lot of connections, say > 100. The "shm" settings will cover you for tens of thousands of shared buffers in postgres. You can obviously tune those down to your taste. --Apple-Mail-3-521504846--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42A89ED6-54B7-43EC-832B-A54F76C0D17B>