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

Re: Migration study, step 1: bulk write performance

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(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:52:46
Message-ID: 1142941966.23597.4.camel@coppola.muc.ecircle.de (view raw or flat)
Thread:
Lists: pgsql-performance
> Did you try mounting ext3 whith data=writeback by chance? People have
> found that makes a big difference in performance.

I'm not sure, there's other people here doing the OS stuff - I'm pretty
much ignorant about what "data=writeback" could mean :-D

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.

Cheers,
Csaba.



In response to

Responses

pgsql-performance by date

Next:From: Steinar H. GundersonDate: 2006-03-21 11:56:18
Subject: Re: Migration study, step 1: bulk write performance
Previous:From: Jim C. NasbyDate: 2006-03-21 11:51:00
Subject: Re: planner with index scan cost way off actual cost,

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