Date: Tue, 23 May 2006 17:30:32 -0400 From: Jung-uk Kim <jkim@FreeBSD.org> To: freebsd-stable@FreeBSD.org Cc: rwatson@FreeBSD.org Subject: Re: PostgreSQL uses more memory on 6.1? Message-ID: <200605231730.34100.jkim@FreeBSD.org> In-Reply-To: <200605231719.56164.jkim@FreeBSD.org> References: <200605231531.18092.kirk@strauser.com> <200605231713.22363.jkim@FreeBSD.org> <200605231719.56164.jkim@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Tuesday 23 May 2006 05:19 pm, Jung-uk Kim wrote: > 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-mess > > > >ag 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'. Okay, I don't know what I am talking about here. It is still kern.ipc.shmmaxpgs to set it. In fact, I found a PR: http://www.freebsd.org/cgi/query-pr.cgi?pr=75542 However, it seems rwatson closed wrong one at the time. :-( Sorry for the noise, Jung-uk Kim
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200605231730.34100.jkim>