Re: [PERFORM] XFS vs Ext3, and schedulers, for WAL

2010-10-11 Thread Josh Berkus
> http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext2_vs_ext3_on_50_spindles_testing_for_postgresql/ > > It doesn't cover XFS but it provides a decent and simple comparison on > ext2/ext3 etc... Yeah, it doesn't test actual log writing, though. Nor specific

Re: [PERFORM] XFS vs Ext3, and schedulers, for WAL

2010-10-11 Thread Joshua D. Drake
On Mon, 2010-10-11 at 10:50 -0700, Josh Berkus wrote: > > There's a number of blog tests floating around comparing XFS and Ext3, > > and the various Linux schedulers, for PGDATA or for an all-in-one mount. > > > > However, the WAL has a rather particular write pattern, and it's > > reasonable to a

Re: [PERFORM] XFS vs Ext3, and schedulers, for WAL

2010-10-11 Thread Josh Berkus
> There's a number of blog tests floating around comparing XFS and Ext3, > and the various Linux schedulers, for PGDATA or for an all-in-one mount. > > However, the WAL has a rather particular write pattern, and it's > reasonable to assume that it shouldn't be optimized the same way as > PGDATA.

[PERFORM] XFS vs Ext3, and schedulers, for WAL

2010-10-06 Thread Josh Berkus
All, There's a number of blog tests floating around comparing XFS and Ext3, and the various Linux schedulers, for PGDATA or for an all-in-one mount. However, the WAL has a rather particular write pattern, and it's reasonable to assume that it shouldn't be optimized the same way as PGDATA. Has an