Date: Tue, 23 May 2006 15:58:26 -0500 From: Kirk Strauser <kirk@strauser.com> To: freebsd-stable@freebsd.org Subject: Re: PostgreSQL uses more memory on 6.1? Message-ID: <200605231558.27248.kirk@strauser.com> In-Reply-To: <D1EB9AC7-D1FD-44B1-BFC3-E399642F342E@cs.hmc.edu> References: <200605231531.18092.kirk@strauser.com> <D1EB9AC7-D1FD-44B1-BFC3-E399642F342E@cs.hmc.edu>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tuesday 23 May 2006 15:37, Marshall Pierce wrote: > You need to adjust the shared memory segments allowed by the kernel; see > /usr/ports/databases/postgresql<your-version>-server/pkg-message-server > for what to add to your kernel config. Most likely, you forgot to move > over your kernel customizations to your new kernel...? Nope, I took care of that: /etc/sysctl.conf: kern.ipc.semmap=256 kern.ipc.shmmax=268435456 /boot/loader.conf kern.ipc.semmni="256" kern.ipc.semmns="512" kern.ipc.semmnu="256" Furthermore, neither of those files (or even my kernel config file) changed between the previous reboot and the one that installed 6.1. At any rate, the kern.ipc.shmmax is much, much greater than the 64MB that I'd been using before for shared_buffers (8192 buffers * 8 KB/buffer). -- Kirk Strauser
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200605231558.27248.kirk>