PostgreSQL uses more memory on 6.1?

Kirk Strauser kirk at
Tue May 23 14:17:29 PDT 2006

On Tuesday 23 May 2006 16:05, Claus Guttesen wrote:

> He probably meant the following kernel-settings:
> options         SHMMAXPGS=393216
> options         SEMMNI=240
> options         SEMMNS=1440
> options         SEMUME=240
> options         SEMMNU=720
> Those are for my quad-opteron server with 8 GB RAM. Adjust
> accordingly. Did you compile a custom-build-kernel or GENERIC?

I hadn't compiled any of those into my custom kernel, as per some now 
long-forgotten web page that said I should use the sysctls to reach the 
same effect.

What I'd *really* like to find is an explanation of how to set those 
numbers.  I'm using a single Xeon with 3GB of RAM and have no idea how high 
to set those, or whether a particular value is too high.  Then again, once 
I figure it out I guess I should have a fair amount of job security.  :-)
Kirk Strauser

More information about the freebsd-stable mailing list