Re: XFS filessystem for Datawarehousing

Jim C. Nasby wrote:
> On Tue, Aug 01, 2006 at 08:42:23PM -0400, Alvaro Herrera wrote:

> > Most likely ext3 was used on the default configuration, which logs data
> > operations as well as metadata, which is what XFS logs. I don't think
> > I've seen any credible comparison between XFS and ext3 with the
> > metadata-only journal option.
> >
> > On the other hand I don't think it makes sense to journal data on a
> > PostgreSQL environment. Metadata is enough, given that we log data on
> > WAL anyway.
>
> Actually, according to http://en.wikipedia.org/wiki/Ext3 the default
> journalling option for ext3 isn't to journal the data (which is actually
> data=journal), but to wait until the data is written before considering
> the metadata to be committed (data=ordered).

Well, we don't need the data to be written before considering metadata
committed. data=writeback is enough for partitions to be dedicated to
PGDATA. Not sure what other FSs do on this front but the ext3 default
leans towards safe rather than speedy.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.