pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Wong <markw@osdl.org>
To: Steve Bergman <steve@rueb.com>
Cc: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-perform <pgsql-performance@postgresql.org>
Subject: Re: fsync vs open_sync
Date: Thu, 9 Sep 2004 10:12:55 -0700
Message-ID: <20040909101255.A3273@osdl.org> (raw)
In-Reply-To: <1094361402.28425.31.camel@voyager.localdomain>
References: <6EE64EF3AB31D5448D0007DD34EEB3412A749A@Herge.rcsinc.local>
	<m3r7ph2x78.fsf@wolfe.cbbrowne.com>
	<1094361402.28425.31.camel@voyager.localdomain>

On Sun, Sep 05, 2004 at 12:16:42AM -0500, Steve Bergman wrote:
> On Sat, 2004-09-04 at 23:47 -0400, Christopher Browne wrote:
> > The world rejoiced as merlin.moncure@rcsonline.com ("Merlin Moncure") wrote:
> > > Ok, you were right.  I made some tests and NTFS is just not very
> > > good in the general case.  I've seen some benchmarks for Reiser4
> > > that are just amazing.
> > 
> > Reiser4 has been sounding real interesting.
> > 
> 
> Are these independent benchmarks, or the benchmarketing at namesys.com?
> Note that the APPEND, MODIFY, and OVERWRITE phases have been turned off
> on the mongo tests and the other tests have been set to a lexical (non
> default for mongo) mode.  I've done some mongo benchmarking myself and
> reiser4 loses to ext3 (data=ordered) in the excluded tests.  APPEND
> phase performance is absolutely *horrible*.  So they just turned off the
> phases in which reiser4 lost and published the remaining results as
> proof that "resier4 is the fastest filesystem".
> 
> See: http://marc.theaimsgroup.com/?l=reiserfs&m=109363302000856
> 
> 
> -Steve Bergman
> 
> 
> 

Reiser4 also isn't optmized for lots of fsyncs (unless it's been done
recently.)  I believe the mention fsync performance in their release
notes.  I've seen this dramatically hurt performance with our OLTP
workload.

-- 
Mark Wong - - markw@osdl.org
Open Source Development Lab Inc - A non-profit corporation
12725 SW Millikan Way - Suite 400 - Beaverton, OR 97005
(503) 626-2455 x 32 (office)
(503) 626-2436      (fax)
http://developer.osdl.org/markw/



view thread (20+ messages)

Message-ID: <20040909101255.A3273@osdl.org>
Permalink:  ../20040909101255.A3273@osdl.org/
Also on:    postgresql.org/message-id/20040909101255.A3273@osdl.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: markw@osdl.org, steve@rueb.com, cbbrowne@acm.org
  Subject: Re: fsync vs open_sync
  In-Reply-To: <20040909101255.A3273@osdl.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox