PostgreSQL uses more memory on 6.1?
jkim at FreeBSD.org
Tue May 23 14:20:20 PDT 2006
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).
I meant 'kern.ipc.shmall', which used to be 'kern.ipc.shmmaxpgs'. :-(
More information about the freebsd-stable