From owner-freebsd-stable@FreeBSD.ORG  Tue May 23 21:17:22 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 CC0C216B18A
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 21:17:22 +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 6C62243D45
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 21:17:15 +0000 (GMT)
	(envelope-from kirk@strauser.com)
Received: from localhost (localhost [127.0.0.1])
	by kanga.honeypot.net (Postfix) with ESMTP id A0CE898D3D
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 16:17:14 -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 CKuEpxI6AqbQ for <freebsd-stable@freebsd.org>;
	Tue, 23 May 2006 16:17:14 -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 0912698D1D
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 16:17:14 -0500 (CDT)
From: Kirk Strauser <kirk@strauser.com>
To: freebsd-stable@freebsd.org
Date: Tue, 23 May 2006 16:17:12 -0500
User-Agent: KMail/1.9.1
References: <200605231531.18092.kirk@strauser.com>
	<200605231558.27248.kirk@strauser.com>
	<b41c75520605231405k6966c07crb39622a45fcc8e@mail.gmail.com>
In-Reply-To: <b41c75520605231405k6966c07crb39622a45fcc8e@mail.gmail.com>
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: <200605231617.12526.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 21:17:29 -0000

On Tuesday 23 May 2006 16:05, Claus Guttesen wrote:

> He probably meant the following kernel-settings:
>
> options         SHMMAXPGS=393216
> options         SEMMNI=240
> options         SEMMNS=1440
> options         SEMUME=240
> options         SEMMNU=720
>
> Those are for my quad-opteron server with 8 GB RAM. Adjust
> accordingly. Did you compile a custom-build-kernel or GENERIC?

I hadn't compiled any of those into my custom kernel, as per some now 
long-forgotten web page that said I should use the sysctls to reach the 
same effect.

What I'd *really* like to find is an explanation of how to set those 
numbers.  I'm using a single Xeon with 3GB of RAM and have no idea how high 
to set those, or whether a particular value is too high.  Then again, once 
I figure it out I guess I should have a fair amount of job security.  :-)
-- 
Kirk Strauser