From owner-freebsd-database@FreeBSD.ORG  Sun Mar 18 12:16:37 2007
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 763F916A401;
	Sun, 18 Mar 2007 12:16:37 +0000 (UTC)
	(envelope-from Axel.Rau@chaos1.de)
Received: from mail1.chaos1.de (Mail1.Chaos1.de [213.160.12.53])
	by mx1.freebsd.org (Postfix) with ESMTP id 13FB013C45E;
	Sun, 18 Mar 2007 12:16:37 +0000 (UTC)
	(envelope-from Axel.Rau@chaos1.de)
Received: from claudius6.in.chaos1.de ([192.168.220.106])
	by mail1.chaos1.de with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.44)
	id 1HSuJP-0000mb-6I; Sun, 18 Mar 2007 13:16:36 +0100
Mime-Version: 1.0 (Apple Message framework v752.2)
In-Reply-To: <b41c75520703160417w672a6b92x38cac65001bc3ea1@mail.gmail.com>
References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE>
	<b41c75520703160417w672a6b92x38cac65001bc3ea1@mail.gmail.com>
Message-Id: <9012051A-E60C-4408-B772-B2A733CE23F8@chaos1.de>
From: Axel Rau <Axel.Rau@chaos1.de>
Date: Sun, 18 Mar 2007 13:16:26 +0100
To: freebsd-database@freebsd.org, FreeBSD AMD list <freebsd-amd64@freebsd.org>
X-Mailer: Apple Mail (2.752.2)
Content-Type: text/plain;
	charset=UTF-8;
	format=flowed
Content-Transfer-Encoding: quoted-printable
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Cc: 
Subject: Re: New Opteron box, dedicated to PostgreSQL
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 18 Mar 2007 12:16:37 -0000


Am 16.03.2007 um 12:17 schrieb Claus Guttesen:

>
> /boot/loader.conf:
>
> kern.ipc.semmni=3D256
> kern.ipc.semmns=3D2048
>
>
> /etc/sysctl.conf:
>

> kern.ipc.somaxconn=3D2048
This one is new to me.
>
> # Suggestions by Vivek Khera from postgresql performance
> kern.ipc.shm_use_phys=3D1
> kern.ipc.shmmax=3D1073741824
> kern.ipc.shmall=3D262144
> kern.ipc.semmsl=3D512
> kern.ipc.semmap=3D256
>
>
> This is on a four-way woodcrest at 3 GHz and 16 GB ram so you may want
> to adjust the values.

Thank you for this valuable info. I will use it as a starting point.

Regards, Axel
---------------------------------------------------------------------
Axel Rau, =E2=98=80Frankfurt , Germany                       +49 69 9514 =
18 0