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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
