From owner-freebsd-stable@FreeBSD.ORG Tue May 23 20:37:29 2006 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 47AE116A8E8 for ; Tue, 23 May 2006 20:37:29 +0000 (UTC) (envelope-from mbp@cs.hmc.edu) Received: from happy-hardcore.st.hmc.edu (happy-hardcore.ST.HMC.Edu [134.173.56.143]) by mx1.FreeBSD.org (Postfix) with ESMTP id CE68F43D76 for ; Tue, 23 May 2006 20:37:28 +0000 (GMT) (envelope-from mbp@cs.hmc.edu) Received: from [134.173.200.13] (WL-13.CINE.HMC.Edu [134.173.200.13]) by happy-hardcore.st.hmc.edu (Postfix) with ESMTP id 7AEF2B95A for ; Tue, 23 May 2006 13:37:28 -0700 (PDT) Mime-Version: 1.0 (Apple Message framework v750) In-Reply-To: <200605231531.18092.kirk@strauser.com> References: <200605231531.18092.kirk@strauser.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: freebsd-stable@freebsd.org Content-Transfer-Encoding: 7bit From: Marshall Pierce Date: Tue, 23 May 2006 13:37:26 -0700 X-Mailer: Apple Mail (2.750) Subject: Re: PostgreSQL uses more memory on 6.1? X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 May 2006 20:37:35 -0000 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-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