PostgreSQL uses more memory on 6.1?
mbp at cs.hmc.edu
Tue May 23 13:37:35 PDT 2006
On May 23, 2006, at 1:31 PM, Kirk Strauser wrote:
> I just upgraded from 6-STABLE as of 2006-02-18 to 6-STABLE as of
> and was surprised to find that PostgreSQL wouldn't start because it
> couldn't allocate enough shared memory. Thing is, I didn't make a
> hardware change during the reboot and didn't upgrade any ports on the
> My emergency fix was to edit postgresql.conf to change
> shared_buffers from
> 8192 to 2048. Unfortunately, that seems to be hurting performance
> - I'm
> getting annoying deadlocks at 4AM whenever multiple daemons start
> overnight batch runs.
> Has anyone else seen this behavior when upgrading from 6.0 to 6.1?
> ideas for a fix?
> I apologize for not having a logfiles, but I was pretty much in a
> panic to
> get it back up and running ASAP and didn't think about it until it
> was too
> Kirk Strauser
You need to adjust the shared memory segments allowed by the kernel; see
what to add to your kernel config. Most likely, you forgot to move
kernel customizations to your new kernel...?
More information about the freebsd-stable