From owner-freebsd-amd64@FreeBSD.ORG  Mon Mar 19 14:37:03 2007
Return-Path: <owner-freebsd-amd64@FreeBSD.ORG>
X-Original-To: freebsd-amd64@FreeBSD.ORG
Delivered-To: freebsd-amd64@FreeBSD.ORG
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id 38DF516A4FF;
	Mon, 19 Mar 2007 14:37:03 +0000 (UTC)
	(envelope-from olli@lurza.secnetix.de)
Received: from lurza.secnetix.de (lurza.secnetix.de [83.120.8.8])
	by mx1.freebsd.org (Postfix) with ESMTP id B734A13C448;
	Mon, 19 Mar 2007 14:37:02 +0000 (UTC)
	(envelope-from olli@lurza.secnetix.de)
Received: from lurza.secnetix.de (qdovsj@localhost [127.0.0.1])
	by lurza.secnetix.de (8.13.4/8.13.4) with ESMTP id l2JEZwRP036992;
	Mon, 19 Mar 2007 15:36:03 +0100 (CET)
	(envelope-from oliver.fromme@secnetix.de)
Received: (from olli@localhost)
	by lurza.secnetix.de (8.13.4/8.13.1/Submit) id l2JEZwjn036991;
	Mon, 19 Mar 2007 15:35:58 +0100 (CET) (envelope-from olli)
Date: Mon, 19 Mar 2007 15:35:58 +0100 (CET)
Message-Id: <200703191435.l2JEZwjn036991@lurza.secnetix.de>
From: Oliver Fromme <olli@lurza.secnetix.de>
To: freebsd-database@FreeBSD.ORG, freebsd-amd64@FreeBSD.ORG, Axel.Rau@chaos1.de
In-Reply-To: <1FDE5616-AF00-416F-B8E8-1D6A584B1126@chaos1.de>
X-Newsgroups: list.freebsd-database
User-Agent: tin/1.8.2-20060425 ("Shillay") (UNIX) (FreeBSD/4.11-STABLE (i386))
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.1.2
	(lurza.secnetix.de [127.0.0.1]);
	Mon, 19 Mar 2007 15:36:03 +0100 (CET)
Cc: 
Subject: Re: New Opteron box, dedicated to PostgreSQL
X-BeenThere: freebsd-amd64@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: freebsd-database@FreeBSD.ORG, freebsd-amd64@FreeBSD.ORG,
	Axel.Rau@chaos1.de
List-Id: Porting FreeBSD to the AMD64 platform <freebsd-amd64.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-amd64>,
	<mailto:freebsd-amd64-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-amd64>
List-Post: <mailto:freebsd-amd64@freebsd.org>
List-Help: <mailto:freebsd-amd64-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-amd64>,
	<mailto:freebsd-amd64-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 19 Mar 2007 14:37:03 -0000

Axel Rau wrote:
 > Oliver Fromme wrote:
 > 
 > > Be sure to disable background fsck via /etc/rc.conf.  I've
 > > seen it breaking file systems under certain circumstances.
 > 
 > Good to know. What about softupdates?

It makes a bit of a difference, but not a big one.  Note
that you should enable fsync in the PostgreSQL config
anyway, which defeats the purpose of softupdates somewhat.

If you disable fsync (and you know what you're doing),
using softupdates will probably improve i/o performance
significantly, but I haven't tried that.  Note that you
might lose data if you setup your DB server that way.

Best regards
   Oliver

PS:  Please respect the Reply-To header.  I don't need
to receive a separate copy of the mail; I'm reading the
list.

-- 
Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing b. M.
Handelsregister: Registergericht Muenchen, HRA 74606,  Geschäftsfuehrung:
secnetix Verwaltungsgesellsch. mbH, Handelsregister: Registergericht Mün-
chen, HRB 125758,  Geschäftsführer: Maik Bachmann, Olaf Erb, Ralf Gebhart

FreeBSD-Dienstleistungen, -Produkte und mehr:  http://www.secnetix.de/bsd

"If you think C++ is not overly complicated, just what is a protected
abstract virtual base pure virtual private destructor, and when was the
last time you needed one?"
        -- Tom Cargil, C++ Journal