PostgreSQL uses more memory on 6.1?

[Jung-uk Kim]

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