Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 21 Jul 2003 14:26:43 -0500
From:      "Jim C. Nasby" <jim@nasby.net>
To:        Jason Stone <freebsd-performance@dfmm.org>
Cc:        freebsd-performance@freebsd.org
Subject:   Re: Tuning for PostGreSQL Database
Message-ID:  <20030721192643.GD55392@nasby.net>
In-Reply-To: <20030721043501.F14379-100000@walter>
References:  <Pine.BSF.4.05.10307191344080.16986-100000@misery.sdf.com> <20030721043501.F14379-100000@walter>

next in thread | previous in thread | raw e-mail | index | archive | help
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?"



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030721192643.GD55392>