From owner-freebsd-stable@FreeBSD.ORG  Wed May 24 16:14:58 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 C566E16A84B
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 16:14:58 +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 2441A43D45
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 16:14:56 +0000 (GMT)
	(envelope-from kirk@strauser.com)
Received: from localhost (localhost [127.0.0.1])
	by kanga.honeypot.net (Postfix) with ESMTP id 1834598F72
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 11:14:55 -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 sWWWyrjM4xgl for <freebsd-stable@freebsd.org>;
	Wed, 24 May 2006 11:14:54 -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 4F22397774
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 11:14:54 -0500 (CDT)
From: Kirk Strauser <kirk@strauser.com>
To: freebsd-stable@freebsd.org
Date: Wed, 24 May 2006 11:14:52 -0500
User-Agent: KMail/1.9.1
References: <200605231531.18092.kirk@strauser.com>
	<42A89ED6-54B7-43EC-832B-A54F76C0D17B@khera.org>
In-Reply-To: <42A89ED6-54B7-43EC-832B-A54F76C0D17B@khera.org>
X-Face: T+/_{qmjgbosI0J/e83I~w[&VF'w)!(<bFJWGw=Vx16yEz`z=a^@7)qZ{yc5m;
	#Q"K(=?iso-8859-1?q?S-T=0A=09p1?=<=?iso-8859-1?q?rTK6XRo=3F8kwsj=26g/ze=2ETkdj=24vrJ4rE=5EspYQA3/qUgm=27Yso?=
	=?iso-8859-1?q?y=27D!05=7CbD*W=5D+F*OPF=25=5E0=0A=09?=>(xEpj///^bA/6?jHHS?nq+T8_+`nh"WnEWCWG,
	\}]Y2$))
	=?iso-8859-1?q?vLVz4ACChrEcb=7DCO=5EtYmMG=5C=0A=09ts=2Em=3F=5B7=5B6OwE*dA?=
	=?iso-8859-1?q?J*9f+mX=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: <200605241114.52666.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: Wed, 24 May 2006 16:15:03 -0000

On Wednesday 24 May 2006 09:11, Vivek Khera wrote:

> no. not seen it.
>
> did you have a custom kernel with higher SHM settings on 6.0?

Nope.  I didn't touch the kernel config at all (it includes GENERIC and then 
adds a couple of nonrelated settings).

> In any case, here is what you do:

Bumping shmall did the trick, but semmsl was pretty low so I bumped it up 
just in case.

Is any of this stuff well documented other than in NOTES?  I can see what 
each setting does, but don't really have a feel for *why* I'd need to 
increase a given setting, what the drawback is to increasing it, or why it 
was so low in the first place.

For that matter, why does this stuff have to be manually configured?  
Couldn't the kernel automatically expand a lot of these numbers as needed?
-- 
Kirk Strauser