On Tue, Mar 24, 2009 at 6:48 PM, Scott Carey <sc...@richrelevance.com> wrote: > Your xlogs are occasionally close to max usage too -- which is suspicious at > 10MB/sec. There is no reason for them to be on ext3 since they are a > transaction log that syncs writes so file system journaling doesn't mean > anything. Ext2 there will lower the sync times and reduced i/o utilization.
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. Performance between the two filesystems should really be negligible for Postgres logging. -Dave -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
