Date: Tue, 23 May 2006 13:37:26 -0700 From: Marshall Pierce <mbp@cs.hmc.edu> Cc: freebsd-stable@freebsd.org Subject: Re: PostgreSQL uses more memory on 6.1? Message-ID: <D1EB9AC7-D1FD-44B1-BFC3-E399642F342E@cs.hmc.edu> In-Reply-To: <200605231531.18092.kirk@strauser.com> References: <200605231531.18092.kirk@strauser.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 > 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 You need to adjust the shared memory segments allowed by the kernel; see /usr/ports/databases/postgresql<your-version>-server/pkg-message- server for what to add to your kernel config. Most likely, you forgot to move over your kernel customizations to your new kernel...? -Marshall
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?D1EB9AC7-D1FD-44B1-BFC3-E399642F342E>