From: Joshua D. Drake <jd@commandprompt.com>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: XFS vs Ext3, and schedulers, for WAL
Date: Mon, 11 Oct 2010 11:06:23 -0700
Message-ID: <1286820383.25541.45.camel@jd-desktop> (raw)
In-Reply-To: <4CB34E50.3080201@agliodbs.com>
References: <4CAD0214.50304@agliodbs.com>
<4CB34E50.3080201@agliodbs.com>
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 assume that it shouldn't be optimized the same way as
> > PGDATA. Has anyone done any head-to-heads for WAL drive configuration
> > changes?
>
> That would be a "no", then. Looks like I have my work cut out for me ...
The only thing I have done is:
http://www.commandprompt.com/blogs/joshua_drake/2008/04/is_that_performance_i_smell_ext2_vs_ext3_on_...
It doesn't cover XFS but it provides a decent and simple comparison on
ext2/ext3 etc...
Remember xlog is sequential so pushing it off is useful.
JD
>
> --
> -- Josh Berkus
> PostgreSQL Experts Inc.
> http://www.pgexperts.com
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, josh@agliodbs.com
Subject: Re: XFS vs Ext3, and schedulers, for WAL
In-Reply-To: <1286820383.25541.45.camel@jd-desktop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox