pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Brown <kevin@sysexperts.com>
To: pgsql-performance@postgresql.org
Subject: Re: Mount options for Ext3?
Date: Fri, 24 Jan 2003 18:50:08 -0800
Message-ID: <20030125025008.GD28252@filer> (raw)
In-Reply-To: <200301241822.33731.josh@agliodbs.com>
References: <200301241120.14404.josh@agliodbs.com>
	<20030125003011.GA28252@filer>
	<200301241822.33731.josh@agliodbs.com>

Josh Berkus wrote:
> Well, the only reason I use Ext3 rather than Ext2 is to prevent fsck's on 
> restart after a crash.    So I'm interested in the data option that gives the 
> minimum performance hit, even if it means that I sacrifice some reliability.   
> I'm running with fsynch on, and the DB is on a mirrored drive array, so I'm 
> not too worried about filesystem-level errors.
> 
> So would that be "data=writeback"?

Yes.  That should give almost the same semantics as ext2 does by
default, except that metadata is journalled, so no fsck needed.  :-)

In fact, I believe that's exactly how ReiserFS works, if I'm not
mistaken (I saw someone claim that it does data journalling, but I've
never seen any references to how to get ReiserFS to journal data).


BTW, why exactly are you running ext3?  It has some nice journalling
features but it sounds like you don't want to use them.  But at the
same time, it uses pre-allocated inodes just like ext2 does, so it's
possible to run out of inodes on ext2/3 while AFAIK that's not
possible under ReiserFS.  That's not likely to be a problem unless
you're running a news server or something, though.  :-)

On the other hand, ext3 with data=writeback will probably be faster
than ReiserFS for a number of things.

No idea how stable ext3 is versus ReiserFS...



-- 
Kevin Brown					      kevin@sysexperts.com



view thread (14+ messages)  latest in thread

Message-ID: <20030125025008.GD28252@filer>
Permalink:  ../20030125025008.GD28252@filer/
Also on:    postgresql.org/message-id/20030125025008.GD28252@filer

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: kevin@sysexperts.com
  Subject: Re: Mount options for Ext3?
  In-Reply-To: <20030125025008.GD28252@filer>
  References: <200301241120.14404.josh@agliodbs.com> <20030125003011.GA28252@filer> <200301241822.33731.josh@agliodbs.com> <20030125025008.GD28252@filer>

* 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