Re: to fsync or not to fsync

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