PostgreSQL uses more memory on 6.1?
Kirk Strauser
kirk at strauser.com
Tue May 23 13:31:47 PDT 2006
I just upgraded from 6-STABLE as of 2006-02-18 to 6-STABLE as of 2006-05-21,
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 single
hardware change during the reboot and didn't upgrade any ports on the
machine.
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 their
overnight batch runs.
Has anyone else seen this behavior when upgrading from 6.0 to 6.1? Any
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
late.
--
Kirk Strauser
More information about the freebsd-stable
mailing list