Re: Raid 10 chunksize - Mailing list pgsql-performance

From Greg Smith
Subject Re: Raid 10 chunksize
Date
Msg-id alpine.GSO.2.01.0903242326090.16570@westnet.com
Whole thread Raw
In response to Re: Raid 10 chunksize  (David Rees <drees76@gmail.com>)
List pgsql-performance
On Tue, 24 Mar 2009, David Rees wrote:

> I would tend to recommend ext3 in data=writeback and make sure that
> it's mounted with noatime over using ext2 - for the sole reason that
> if the system shuts down unexpectedly, you don't have to worry about a
> long fsck when bringing it back up.

Well, Mark's system is already using noatime, and if you believe

http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext2_vs_ext3_on_50_spindles_testing_for_postgresql/

there's little difference between writeback and ordered on the WAL disk.
Might squeeze out some improvements with ext2 though, and if there's
nothing besides the WAL on there fsck isn't ever going to take very long
anyway--not much of a directory tree to traverse there.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: marcin mank
Date:
Subject: Re: Help Me Understand Why I'm Getting a Bad Query Plan
Next
From: Bryan Murphy
Date:
Subject: Re: Help Me Understand Why I'm Getting a Bad Query Plan