From owner-freebsd-stable@FreeBSD.ORG  Wed May 24 23:24:49 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 9794F16A432
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 23:24:49 +0000 (UTC)
	(envelope-from markir@paradise.net.nz)
Received: from linda-4.paradise.net.nz (bm-4a.paradise.net.nz [203.96.152.183])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 275C243D48
	for <freebsd-stable@freebsd.org>; Wed, 24 May 2006 23:24:48 +0000 (GMT)
	(envelope-from markir@paradise.net.nz)
Received: from smtp-1.paradise.net.nz
	(tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by
	linda-4.paradise.net.nz (Paradise.net.nz) with ESMTP id
	<0IZS001XWMDA70@linda-4.paradise.net.nz> for
	freebsd-stable@freebsd.org; Thu, 25 May 2006 11:24:47 +1200 (NZST)
Received: from [192.168.1.11]
	(218-101-29-172.dsl.clear.net.nz [218.101.29.172])	by
	smtp-1.paradise.net.nz (Postfix) with ESMTP id 0CED138B452;
	Thu, 25 May 2006 11:24:26 +1200 (NZST)
Date: Thu, 25 May 2006 11:23:57 +1200
From: Mark Kirkwood <markir@paradise.net.nz>
In-reply-to: <200605241114.52666.kirk@strauser.com>
To: Kirk Strauser <kirk@strauser.com>
Message-id: <4474EB0D.5020105@paradise.net.nz>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7bit
User-Agent: Thunderbird 1.5 (X11/20060417)
References: <200605231531.18092.kirk@strauser.com>
	<42A89ED6-54B7-43EC-832B-A54F76C0D17B@khera.org>
	<200605241114.52666.kirk@strauser.com>
Cc: freebsd-stable@freebsd.org
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 23:24:49 -0000

Kirk Strauser wrote:

> 
> 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 the configuration of IPC for Postgresql, see:

http://www.postgresql.org/docs/8.1/static/kernel-resources.html#SYSVIPC

And scroll down to the section for FreeBSD.

Unfortunately, that whole section on kernel resources is a bit hidden 
away - it usually takes me a couple of attempts to find it!

cheers

Mark