From owner-freebsd-database@FreeBSD.ORG  Fri Mar 16 11:45:45 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 D317116A406
	for <freebsd-database@freebsd.org>;
	Fri, 16 Mar 2007 11:45:45 +0000 (UTC)
	(envelope-from kometen@gmail.com)
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168])
	by mx1.freebsd.org (Postfix) with ESMTP id 6565E13C45E
	for <freebsd-database@freebsd.org>;
	Fri, 16 Mar 2007 11:45:44 +0000 (UTC)
	(envelope-from kometen@gmail.com)
Received: by ug-out-1314.google.com with SMTP id 71so654233ugh
	for <freebsd-database@freebsd.org>;
	Fri, 16 Mar 2007 04:45:44 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=qY5q5UGIcc3yaJV9smB3GHSls5Ip/xQ53I7zh1clLX8vrryTZBPB/cLLPawKdoG+QfLhW89hipAPXUhXJZ7/bLnyFokOCh+CaAGYUNwHpv6qM7oYJX6JyUtKjtRUAmVow8U0OUjHX6etGL8MSCXFdhQbuSSjbHEA6liY7MuvMps=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=hvGS0nvSlmXoz5oC44U9S6fL1e8s5Y0TDEtBK5vPCuOF4PMxQSVOrN4ji+onawTuBmn+lrspllujqtJHJUA7lnDRxSGESIdXmy7GMVTP5sTmt5SzGwCC9Us4a0viMpAAORaUkBoI5Er+WW+IDZaXlZYs1dSpnOEmGgnjgI4jCZ0=
Received: by 10.115.77.1 with SMTP id e1mr667752wal.1174043836066;
	Fri, 16 Mar 2007 04:17:16 -0700 (PDT)
Received: by 10.114.194.12 with HTTP; Fri, 16 Mar 2007 04:17:16 -0700 (PDT)
Message-ID: <b41c75520703160417w672a6b92x38cac65001bc3ea1@mail.gmail.com>
Date: Fri, 16 Mar 2007 12:17:16 +0100
From: "Claus Guttesen" <kometen@gmail.com>
To: "Axel Rau" <Axel.Rau@chaos1.de>
In-Reply-To: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <8CDBEAF9-0945-4CD2-89C4-58AA63850ECC@Chaos1.DE>
Cc: freebsd-database@freebsd.org, freebsd-amd64@freebsd.org
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: Fri, 16 Mar 2007 11:45:45 -0000

> while configuring my 1st PostgreSQL box with dual Opterons (2212) on
> FreeBSD, I have some questions:
>
> 3. What are the recommendations for tuning I/O)?
>     - setting sysctl vfs.read_max to 16 or 32
>     - rebuilding the relevant filesystem with 32K blocks and 4K frags
>     Are these reliable?

The following were suggetions from Vivek Khera:


/boot/loader.conf:

kern.ipc.semmni=256
kern.ipc.semmns=2048


/etc/sysctl.conf:

kern.ipc.somaxconn=2048
kern.maxfiles=65536

# Suggestions by Vivek Khera from postgresql performance
kern.ipc.shm_use_phys=1
kern.ipc.shmmax=1073741824
kern.ipc.shmall=262144
kern.ipc.semmsl=512
kern.ipc.semmap=256


This is on a four-way woodcrest at 3 GHz and 16 GB ram so you may want
to adjust the values.

regards
Claus