Date: Tue, 23 May 2006 17:13:20 -0400 From: Jung-uk Kim <jkim@FreeBSD.org> To: freebsd-stable@FreeBSD.org Subject: Re: PostgreSQL uses more memory on 6.1? Message-ID: <200605231713.22363.jkim@FreeBSD.org> In-Reply-To: <200605231558.27248.kirk@strauser.com> References: <200605231531.18092.kirk@strauser.com> <D1EB9AC7-D1FD-44B1-BFC3-E399642F342E@cs.hmc.edu> <200605231558.27248.kirk@strauser.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tuesday 23 May 2006 04:58 pm, Kirk Strauser wrote: > 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). kern.ipc.shmmaxpgs? Jung-uk Kim
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200605231713.22363.jkim>