From owner-freebsd-stable@FreeBSD.ORG  Tue May 23 20:58:50 2006
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
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 444C716AF36
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 20:58:50 +0000 (UTC)
	(envelope-from kirk@strauser.com)
Received: from kanga.honeypot.net (kanga.honeypot.net [208.162.254.122])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 7295A43D45
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 20:58:30 +0000 (GMT)
	(envelope-from kirk@strauser.com)
Received: from localhost (localhost [127.0.0.1])
	by kanga.honeypot.net (Postfix) with ESMTP id 2215D98D34
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 15:58:30 -0500 (CDT)
X-Virus-Scanned: amavisd-new at honeypot.net
Received: from kanga.honeypot.net ([127.0.0.1])
	by localhost (kanga.honeypot.net [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id UAlW4GtRBWHH for <freebsd-stable@freebsd.org>;
	Tue, 23 May 2006 15:58:28 -0500 (CDT)
Received: from janus.daycos.com (janus.daycos.com [204.26.70.77])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by kanga.honeypot.net (Postfix) with ESMTP id C4AE198BE2
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 15:58:28 -0500 (CDT)
From: Kirk Strauser <kirk@strauser.com>
To: freebsd-stable@freebsd.org
Date: Tue, 23 May 2006 15:58:26 -0500
User-Agent: KMail/1.9.1
References: <200605231531.18092.kirk@strauser.com>
	<D1EB9AC7-D1FD-44B1-BFC3-E399642F342E@cs.hmc.edu>
In-Reply-To: <D1EB9AC7-D1FD-44B1-BFC3-E399642F342E@cs.hmc.edu>
X-Face: T+/_{qmjgbosI0J/e83I~w[&VF'w)!(<bFJWGw=Vx16yEz`z=a^@7)qZ{yc5m;
	#Q"K(=?utf-8?q?S-T=0A=09p1?=<=?utf-8?q?rTK6XRo=3F8kwsj=26g/ze=2ETkdj=24vrJ4rE=5EspYQA3/qUgm=27Ysoy=27D!?=
	=?utf-8?q?05=7CbD*W=5D+F*OPF=25=5E0=0A=09?=>(xEpj///^bA/6?jHHS?nq+T8_+`nh"WnEWCWG,
	\}]Y2$))
	=?utf-8?q?vLVz4ACChrEcb=7DCO=5EtYmMG=5C=0A=09ts=2Em=3F=5B7=5B6OwE*dAJ*9f+m?=
	=?utf-8?q?X=2E7R32qeN=5EDJ=5C?=(k@evW?IRQCy.^
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200605231558.27248.kirk@strauser.com>
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 <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 23 May 2006 20:58:54 -0000

On Tuesday 23 May 2006 15:37, Marshall Pierce wrote:

> 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...?  

Nope, I took care of that:

/etc/sysctl.conf:

kern.ipc.semmap=256
kern.ipc.shmmax=268435456

/boot/loader.conf

kern.ipc.semmni="256"
kern.ipc.semmns="512"
kern.ipc.semmnu="256"

Furthermore, neither of those files (or even my kernel config file) changed 
between the previous reboot and the one that installed 6.1.  At any rate, 
the kern.ipc.shmmax is much, much greater than the 64MB that I'd been using 
before for shared_buffers (8192 buffers * 8 KB/buffer).
-- 
Kirk Strauser