From: Alvaro Herrera <alvherre@commandprompt.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: J. Andrew Rogers <jrogers@neopolitan.com>
Cc: Milen Kulev <makulev@gmx.net>
Cc: Pgsql-Performance ((E-mail)) <pgsql-performance@postgresql.org>
Subject: Re: XFS filessystem for Datawarehousing
Date: Mon, 7 Aug 2006 12:55:16 -0400
Message-ID: <20060807165516.GA26021@alvh.no-ip.org> (raw)
In-Reply-To: <20060804204450.GS40481@pervasive.com>
References: <012d01c6b5b4$6db33680$0a00a8c0@trivadis.com>
<D986D872-2CE4-4D12-B368-2F4494CFE08B@neopolitan.com>
<20060802004223.GE20401@alvh.no-ip.org>
<20060804204450.GS40481@pervasive.com>
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.
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: alvherre@commandprompt.com, jnasby@pervasive.com, jrogers@neopolitan.com, makulev@gmx.net
Subject: Re: XFS filessystem for Datawarehousing
In-Reply-To: <20060807165516.GA26021@alvh.no-ip.org>
* 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