From owner-freebsd-questions@FreeBSD.ORG Tue May 23 20:59:05 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 7C6E316AACE for ; Tue, 23 May 2006 20:59:05 +0000 (UTC) (envelope-from danielby@slightlystrange.org) Received: from catflap.slightlystrange.org (cpc6-cmbg1-0-0-cust82.cmbg.cable.ntl.com [82.10.236.83]) by mx1.FreeBSD.org (Postfix) with ESMTP id A987643D6D for ; Tue, 23 May 2006 20:58:57 +0000 (GMT) (envelope-from danielby@slightlystrange.org) Received: from danielby by catflap.slightlystrange.org with local (Exim 4.62 #0) id 1Fidxw-000Ld8-EX by authid for ; Tue, 23 May 2006 21:58:56 +0100 Date: Tue, 23 May 2006 21:58:56 +0100 From: Daniel Bye To: freebsd-questions@freebsd.org Message-ID: <20060523205856.GE38758@catflap.slightlystrange.org> Mail-Followup-To: freebsd-questions@freebsd.org References: <200605231537.26304.kirk@strauser.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="SnV5plBeK2Ge1I9g" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4.2.1i X-SA-Exim-Connect-IP: X-SA-Exim-Mail-From: danielby@slightlystrange.org X-SA-Exim-Scanned: No (on catflap.slightlystrange.org); SAEximRunCond expanded to false Subject: Re: PostgreSQL uses more memory on 6.1? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Daniel Bye List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 23 May 2006 20:59:07 -0000 --SnV5plBeK2Ge1I9g Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, May 23, 2006 at 02:47:54PM -0600, Chad Leigh -- Shire.Net LLC wrote: >=20 > On May 23, 2006, at 2:37 PM, Kirk Strauser wrote: >=20 > >I just upgraded from 6-STABLE as of 2006-02-18 to 6-STABLE as of =20 > >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 =20 > >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 =20 > >shared_buffers from > >8192 to 2048. Unfortunately, that seems to be hurting performance =20 > >- I'm > >getting annoying deadlocks at 4AM whenever multiple daemons start =20 > >their > >overnight batch runs. > > > >Has anyone else seen this behavior when upgrading from 6.0 to 6.1? =20 > >Any > >ideas for a fix? >=20 >=20 > Just a guess -- did some kernel default for shared memory change or =20 > did you change your kernel config? Can you rebuild your kernel with =20 > explicit shared memory values? Look in the NOTES in /usr/src/sys/=20 > conf at the various SHM values Yep, I was thinking along the same lines. The PostgreSQL ports have a pkg-message-server file that may prove helpful, too. >=20 >=20 > not an expert Likewise... --=20 Daniel Bye PGP Key: http://www.slightlystrange.org/pgpkey-dan.asc PGP Key fingerprint: D349 B109 0EB8 2554 4D75 B79A 8B17 F97C 1622 166A _ ASCII ribbon campaign ( ) - against HTML, vCards and X - proprietary attachments in e-mail / \ --SnV5plBeK2Ge1I9g Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (FreeBSD) iD8DBQFEc3eQixf5fBYiFmoRAoiUAKDO40YgIMrb/1V2mQ3tpi78weS+LwCggIBG NOkSWXDTZDIH/jJhORFTlj8= =17GP -----END PGP SIGNATURE----- --SnV5plBeK2Ge1I9g--