Date: Tue, 23 May 2006 17:19:52 -0400 From: Jung-uk Kim <jkim@FreeBSD.org> To: freebsd-stable@FreeBSD.org Subject: Re: PostgreSQL uses more memory on 6.1? Message-ID: <200605231719.56164.jkim@FreeBSD.org> In-Reply-To: <200605231713.22363.jkim@FreeBSD.org> References: <200605231531.18092.kirk@strauser.com> <200605231558.27248.kirk@strauser.com> <200605231713.22363.jkim@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tuesday 23 May 2006 05:13 pm, Jung-uk Kim wrote: > 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-messag > > >e- 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? I meant 'kern.ipc.shmall', which used to be 'kern.ipc.shmmaxpgs'. :-( Jung-uk Kim
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200605231719.56164.jkim>