From owner-freebsd-performance@FreeBSD.ORG  Mon Jul 21 12:26:50 2003
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id E93AE37B401
	for <freebsd-performance@freebsd.org>;
	Mon, 21 Jul 2003 12:26:49 -0700 (PDT)
Received: from flake.decibel.org (flake.decibel.org [66.143.173.58])
	by mx1.FreeBSD.org (Postfix) with SMTP id 7FADB43F85
	for <freebsd-performance@freebsd.org>;
	Mon, 21 Jul 2003 12:26:48 -0700 (PDT)
	(envelope-from decibel@decibel.org)
Received: (qmail 77454 invoked by uid 1001); 21 Jul 2003 19:26:43 -0000
Date: Mon, 21 Jul 2003 14:26:43 -0500
From: "Jim C. Nasby" <jim@nasby.net>
To: Jason Stone <freebsd-performance@dfmm.org>
Message-ID: <20030721192643.GD55392@nasby.net>
References: <Pine.BSF.4.05.10307191344080.16986-100000@misery.sdf.com>
	<20030721043501.F14379-100000@walter>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20030721043501.F14379-100000@walter>
User-Agent: Mutt/1.4.1i
X-Operating-System: FreeBSD 4.8-RELEASE i386
X-Distributed: Join the Effort!  http://www.distributed.net
cc: freebsd-database@freebsd.org
cc: freebsd-performance@freebsd.org
Subject: Re: Tuning for PostGreSQL Database
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 21 Jul 2003 19:26:50 -0000

On Mon, Jul 21, 2003 at 05:06:47AM -0700, Jason Stone wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> 
> On Sat, 19 Jul 2003, Tom Samplonius wrote:
> > Softupdates on, async off.  Softupdates is just a better async.
> 
> postgresql fsync's all its files before returning from a commit in order
> to ensure durability, right?  Does softupdates interfere with the
> functioning of sync(2)/fsync(2)?
 
No, afaik it only fsync's the write-ahead-logs.
-- 
Jim C. Nasby, Database Consultant                  jim@nasby.net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"