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(dot)hsueh(at)gmail(dot)com