From owner-freebsd-questions@FreeBSD.ORG Tue May 23 20:47:56 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id D3E7C16AD85 for ; Tue, 23 May 2006 20:47:56 +0000 (UTC) (envelope-from chad@shire.net) Received: from hobbiton.shire.net (mail.shire.net [166.70.252.250]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5BA6E43D5E for ; Tue, 23 May 2006 20:47:56 +0000 (GMT) (envelope-from chad@shire.net) Received: from [67.171.127.191] (helo=[192.168.99.68]) by hobbiton.shire.net with esmtpa (Exim 4.51) id 1FidnH-000FOx-MM; Tue, 23 May 2006 14:47:55 -0600 In-Reply-To: <200605231537.26304.kirk@strauser.com> References: <200605231537.26304.kirk@strauser.com> Mime-Version: 1.0 (Apple Message framework v750) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: "Chad Leigh -- Shire.Net LLC" Date: Tue, 23 May 2006 14:47:54 -0600 To: Kirk Strauser X-Mailer: Apple Mail (2.750) X-SA-Exim-Connect-IP: 67.171.127.191 X-SA-Exim-Mail-From: chad@shire.net X-SA-Exim-Scanned: No (on hobbiton.shire.net); SAEximRunCond expanded to false Cc: freebsd-questions@freebsd.org Subject: Re: PostgreSQL uses more memory on 6.1? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 May 2006 20:48:04 -0000 On May 23, 2006, at 2:37 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? Just a guess -- did some kernel default for shared memory change or did you change your kernel config? Can you rebuild your kernel with explicit shared memory values? Look in the NOTES in /usr/src/sys/ conf at the various SHM values not an expert Chad --- Chad Leigh -- Shire.Net LLC Your Web App and Email hosting provider chad at shire.net