PostgreSQL uses more memory on 6.1?

Kirk Strauser kirk at strauser.com
Tue May 23 13:37: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-questions mailing list