PostgreSQL uses more memory on 6.1?
vivek at khera.org
Wed May 24 07:11:59 PDT 2006
On May 23, 2006, at 4:31 PM, Kirk Strauser wrote:
> Has anyone else seen this behavior when upgrading from 6.0 to 6.1?
> ideas for a fix?
no. not seen it.
did you have a custom kernel with higher SHM settings on 6.0?
In any case, here is what you do:
in /etc/sysctl.conf add these:
and in /boot/loader.conf add these:
the "sem" variables are really only needed if you want a lot of
connections, say > 100. The "shm" settings will cover you for tens
of thousands of shared buffers in postgres. You can obviously tune
those down to your taste.
More information about the freebsd-stable