Re: to fsync or not to fsync - Mailing list pgsql-performance

From Frank Hsueh
Subject Re: to fsync or not to fsync
Date
Msg-id 753644204070608452ac91892@mail.gmail.com
Whole thread Raw
In response to to fsync or not to fsync  (Rodrigo Filgueira <rfilgue@cinterfor.org.uy>)
Responses Re: to fsync or not to fsync (ext3?)
List pgsql-performance
Rodrigo,

> Hello there, I'm trying to make sure my postgres 7.4 is running as fast
> as it can in my box.

> ...

> My Software config is:
>
> RedHat 7.3 - 2.4.20-28.7smp Kernel, reporting four processors because of
> hyper threading.
> Postgres 7.4
> Data directory is on a ext3 journaled filesystem (data=journal)

Isn't ext3 a really slow journaled filesystem [1, 2] to begin with?

[1] http://slashdot.org/article.pl?sid=04/05/11/134214
[2] http://209.81.41.149/~jpiszcz/index.html

It might be a good experiment to figure out how different file systems
affect perf.

--
Frank Hsueh, EngSci Elec 0T3 + 1

email: frank.hsueh@gmail.com

pgsql-performance by date:

Previous
From: Rodrigo Filgueira
Date:
Subject: to fsync or not to fsync
Next
From: Rodrigo Filgueira
Date:
Subject: Re: to fsync or not to fsync (ext3?)