Re: Migration study, step 1: bulk write performance - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Migration study, step 1: bulk write performance
Date
Msg-id 20060321115618.GA12880@uio.no
Whole thread Raw
In response to Re: Migration study, step 1: bulk write performance  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Migration study, step 1: bulk write performance  (Csaba Nagy <nagy@ecircle-ag.com>)
Re: Migration study, step 1: bulk write performance  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
On Tue, Mar 21, 2006 at 12:52:46PM +0100, Csaba Nagy wrote:
> They knew however that for the data partitions no FS journaling is
> needed, and for the WAL partition meta data journaling is enough, so I
> guess they tuned ext3 for this.

For the record, that's the wrong way round. For the data partitioning
metadata journaling is enough, and for the WAL partition you don't need any
FS journaling at all.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Migration study, step 1: bulk write performance
Next
From: "Jim C. Nasby"
Date:
Subject: Re: planner with index scan cost way off actual cost, advices to tweak cost constants?