From owner-freebsd-stable@FreeBSD.ORG  Tue May 23 21:30: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 C8FE816B3BE;
	Tue, 23 May 2006 21:30:50 +0000 (UTC)
	(envelope-from jkim@FreeBSD.org)
Received: from anuket.mj.niksun.com (gwnew.niksun.com [65.115.46.162])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 163A043D7F;
	Tue, 23 May 2006 21:30:47 +0000 (GMT)
	(envelope-from jkim@FreeBSD.org)
Received: from niksun.com (anuket [10.70.0.5])
	by anuket.mj.niksun.com (8.13.1/8.13.1) with ESMTP id k4NLUk2s045079;
	Tue, 23 May 2006 17:30:46 -0400 (EDT)
	(envelope-from jkim@FreeBSD.org)
From: Jung-uk Kim <jkim@FreeBSD.org>
To: freebsd-stable@FreeBSD.org
Date: Tue, 23 May 2006 17:30:32 -0400
User-Agent: KMail/1.6.2
References: <200605231531.18092.kirk@strauser.com>
	<200605231713.22363.jkim@FreeBSD.org>
	<200605231719.56164.jkim@FreeBSD.org>
In-Reply-To: <200605231719.56164.jkim@FreeBSD.org>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <200605231730.34100.jkim@FreeBSD.org>
X-Virus-Scanned: ClamAV 0.88/1478/Mon May 22 17:01:38 2006 on
	anuket.mj.niksun.com
X-Virus-Status: Clean
Cc: rwatson@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: Tue, 23 May 2006 21:30:53 -0000

On Tuesday 23 May 2006 05:19 pm, Jung-uk Kim wrote:
> On Tuesday 23 May 2006 05:13 pm, Jung-uk Kim wrote:
> > On Tuesday 23 May 2006 04:58 pm, Kirk Strauser wrote:
> > > 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-mess
> > > >ag e- 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).
> >
> > kern.ipc.shmmaxpgs?
>
> I meant 'kern.ipc.shmall', which used to be 'kern.ipc.shmmaxpgs'.

Okay, I don't know what I am talking about here.  It is still 
kern.ipc.shmmaxpgs to set it.  In fact, I found a PR:

http://www.freebsd.org/cgi/query-pr.cgi?pr=75542

However, it seems rwatson closed wrong one at the time. :-(

Sorry for the noise,

Jung-uk Kim