From owner-freebsd-stable@FreeBSD.ORG  Tue May 23 21:05:12 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 E06BC16B018
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 21:05:12 +0000 (UTC)
	(envelope-from kometen@gmail.com)
Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.203])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3EBDB43D5E
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 21:05:02 +0000 (GMT)
	(envelope-from kometen@gmail.com)
Received: by wx-out-0102.google.com with SMTP id i30so865998wxd
	for <freebsd-stable@freebsd.org>; Tue, 23 May 2006 14:05:01 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=n2y6e4IPyxBYpvyNRB/dx8XQQhjt+UwP9LxgzgVSAFvzjVIVhqNTApL0fC7b4fj04Qn/kLZrQ+PKMhai0ooXsH9t5JkpHWCenJnh4OlAmfc6aTmCJeA88OZGbbpAC00Bp2pRBNiJHXkepmh7l0jJfsru4F7dJdx75fpxqiGiDUE=
Received: by 10.70.60.6 with SMTP id i6mr6855167wxa;
	Tue, 23 May 2006 14:05:01 -0700 (PDT)
Received: by 10.70.22.2 with HTTP; Tue, 23 May 2006 14:05:01 -0700 (PDT)
Message-ID: <b41c75520605231405k6966c07crb39622a45fcc8e@mail.gmail.com>
Date: Tue, 23 May 2006 23:05:01 +0200
From: "Claus Guttesen" <kometen@gmail.com>
To: "Kirk Strauser" <kirk@strauser.com>
In-Reply-To: <200605231558.27248.kirk@strauser.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <200605231531.18092.kirk@strauser.com>
	<D1EB9AC7-D1FD-44B1-BFC3-E399642F342E@cs.hmc.edu>
	<200605231558.27248.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: Tue, 23 May 2006 21:05:18 -0000

> > You need to adjust the shared memory segments allowed by the kernel; se=
e
> > /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=3D256
> kern.ipc.shmmax=3D268435456
>
> /boot/loader.conf
>
> kern.ipc.semmni=3D"256"
> kern.ipc.semmns=3D"512"
> kern.ipc.semmnu=3D"256"
>
> Furthermore, neither of those files (or even my kernel config file) chang=
ed
> 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 usi=
ng
> before for shared_buffers (8192 buffers * 8 KB/buffer).

He probably meant the following kernel-settings:

options         SHMMAXPGS=3D393216
options         SEMMNI=3D240
options         SEMMNS=3D1440
options         SEMUME=3D240
options         SEMMNU=3D720

Those are for my quad-opteron server with 8 GB RAM. Adjust
accordingly. Did you compile a custom-build-kernel or GENERIC?

regards
Claus