Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 23 May 2006 15:37:25 -0500
From:      Kirk Strauser <kirk@strauser.com>
To:        freebsd-questions@freebsd.org
Subject:   PostgreSQL uses more memory on 6.1?
Message-ID:  <200605231537.26304.kirk@strauser.com>

next in thread | raw e-mail | index | archive | help
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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200605231537.26304.kirk>