From owner-freebsd-stable@FreeBSD.ORG  Wed May 24 14:11:59 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 8593A16A48E
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 14:11:59 +0000 (UTC)
	(envelope-from vivek@khera.org)
Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 7937A43D5C
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 14:11:57 +0000 (GMT)
	(envelope-from vivek@khera.org)
Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103])
	by yertle.kcilink.com (Postfix) with ESMTP id F2A61B826
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 10:11:53 -0400 (EDT)
Mime-Version: 1.0 (Apple Message framework v750)
In-Reply-To: <200605231531.18092.kirk@strauser.com>
References: <200605231531.18092.kirk@strauser.com>
Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-3-521504846;
	protocol="application/pkcs7-signature"
Message-Id: <42A89ED6-54B7-43EC-832B-A54F76C0D17B@khera.org>
From: Vivek Khera <vivek@khera.org>
Date: Wed, 24 May 2006 10:11:52 -0400
To: FreeBSD Stable <freebsd-stable@freebsd.org>
X-Mailer: Apple Mail (2.750)
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
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: Wed, 24 May 2006 14:11:59 -0000


--Apple-Mail-3-521504846
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=US-ASCII;
	delsp=yes;
	format=flowed


On May 23, 2006, at 4:31 PM, Kirk Strauser wrote:

> Has anyone else seen this behavior when upgrading from 6.0 to 6.1?   
> Any
> ideas for a fix?
>

no. not seen it.

did you have a custom kernel with higher SHM settings on 6.0?

In any case, here is what you do:

in /etc/sysctl.conf add these:

kern.ipc.shm_use_phys=1
kern.ipc.shmmax=1073741824
kern.ipc.shmall=262144
kern.ipc.semmsl=512
kern.ipc.semmap=256

and in /boot/loader.conf add these:

kern.ipc.semmni=32
kern.ipc.semmns=512


the "sem" variables are really only needed if you want a lot of  
connections, say > 100.  The "shm" settings will cover you for tens  
of thousands of shared buffers in postgres.  You can obviously tune  
those down to your taste.




--Apple-Mail-3-521504846--