Date: Tue, 23 May 2006 23:05:01 +0200 From: "Claus Guttesen" <kometen@gmail.com> To: "Kirk Strauser" <kirk@strauser.com> Cc: freebsd-stable@freebsd.org Subject: Re: PostgreSQL uses more memory on 6.1? Message-ID: <b41c75520605231405k6966c07crb39622a45fcc8e@mail.gmail.com> 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
> > You need to adjust the shared memory segments allowed by the kernel; se= e > > /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=3D256 > kern.ipc.shmmax=3D268435456 > > /boot/loader.conf > > kern.ipc.semmni=3D"256" > kern.ipc.semmns=3D"512" > kern.ipc.semmnu=3D"256" > > Furthermore, neither of those files (or even my kernel config file) chang= ed > 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 usi= ng > before for shared_buffers (8192 buffers * 8 KB/buffer). He probably meant the following kernel-settings: options SHMMAXPGS=3D393216 options SEMMNI=3D240 options SEMMNS=3D1440 options SEMUME=3D240 options SEMMNU=3D720 Those are for my quad-opteron server with 8 GB RAM. Adjust accordingly. Did you compile a custom-build-kernel or GENERIC? regards Claus
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?b41c75520605231405k6966c07crb39622a45fcc8e>