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: [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html