From owner-freebsd-stable@FreeBSD.ORG  Tue May 23 21:14:03 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 D08AE16AFEB
	for <freebsd-stable@FreeBSD.org>; Tue, 23 May 2006 21:14:03 +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 87ED843D5A
	for <freebsd-stable@FreeBSD.org>; Tue, 23 May 2006 21:14:00 +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 k4NLDZTC044469;
	Tue, 23 May 2006 17:13:35 -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:13:20 -0400
User-Agent: KMail/1.6.2
References: <200605231531.18092.kirk@strauser.com>
	<D1EB9AC7-D1FD-44B1-BFC3-E399642F342E@cs.hmc.edu>
	<200605231558.27248.kirk@strauser.com>
In-Reply-To: <200605231558.27248.kirk@strauser.com>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <200605231713.22363.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: 
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:14:10 -0000

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-message-
> >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?

Jung-uk Kim