Skip site navigation (1) Skip section navigation (2)

Re: Mount options for Ext3?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Kevin Brown <kevin(at)sysexperts(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Mount options for Ext3?
Date: 2003-01-27 20:11:18
Message-ID: 200301272011.h0RKBI227504@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Let me add that I have heard that on Linux XFS is better for PostgreSQL
than either ext3 or Reiser.

---------------------------------------------------------------------------

Kevin Brown wrote:
> 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(at)sysexperts(dot)com
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-performance by date

Next:From: Bruce MomjianDate: 2003-01-27 20:26:27
Subject: Re: WAL replay logic (was Re: [PERFORM] Mount options for Ext3?)
Previous:From: Ron JohnsonDate: 2003-01-27 19:55:04
Subject: Re: bigserial vs serial - which one I'd have to use?

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-01-27 20:14:57
Subject: Re: [SQL] Function for adding Money type
Previous:From: Ron JohnsonDate: 2003-01-27 19:43:48
Subject: Re: Mount options for Ext3?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group