Skip site navigation (1) Skip section navigation (2)

Re: Migration study, step 1: bulk write performance

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Mikael Carneholm <Mikael(dot)Carneholm(at)WirelessCar(dot)com>,postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Migration study, step 1: bulk write performance
Date: 2006-03-21 11:56:18
Message-ID: 20060321115618.GA12880@uio.no (view raw or flat)
Thread:
Lists: 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/

In response to

Responses

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2006-03-21 11:58:35
Subject: Re: planner with index scan cost way off actual cost, advices to tweak cost constants?
Previous:From: Csaba NagyDate: 2006-03-21 11:52:46
Subject: Re: Migration study, step 1: bulk write performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group