From: Csaba Nagy <nagy@ecircle-ag.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Mikael Carneholm <Mikael.Carneholm@WirelessCar.com>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: Migration study, step 1: bulk write performance
Date: Tue, 21 Mar 2006 12:52:46 +0100
Message-ID: <1142941966.23597.4.camel@coppola.muc.ecircle.de> (raw)
In-Reply-To: <20060321112759.GF15742@pervasive.com>
References: <7F10D26ECFA1FB458B89C5B4B0D72C2B088286@sesrv12.wirelesscar.com>
<1142867952.16487.96.camel@coppola.muc.ecircle.de>
<20060321112759.GF15742@pervasive.com>
> 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.
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: nagy@ecircle-ag.com, jnasby@pervasive.com, Mikael.Carneholm@WirelessCar.com
Subject: Re: Migration study, step 1: bulk write performance
In-Reply-To: <1142941966.23597.4.camel@coppola.muc.ecircle.de>
* 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