From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: XFS vs Ext3, and schedulers, for WAL |
Date: | 2010-10-11 18:06:23 |
Message-ID: | 1286820383.25541.45.camel@jd-desktop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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:
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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2010-10-11 18:59:20 | Re: XFS vs Ext3, and schedulers, for WAL |
Previous Message | Josh Berkus | 2010-10-11 17:50:08 | Re: XFS vs Ext3, and schedulers, for WAL |