Hi all,

> Within psql/mysql:
> 1) select count(*) from File;                    1sec    30min

Disclaimer: I don't know a dime's worth of databases per se. But I
spend a lot of time hunting other peoples performance issues. :)

I think you should start identifying the cause for this bit at the
very first, as it shows the absolutely worst perfomance and probably
what slows this also slows the rest.
My nose says this is really smelly and should'nt even take as long
without any indexes.

Can you verify whether the system swaps during your test commands or doesn't?

sar -dp 100 1 | grep -v nodev will do nicely with the external storage.

also can you please let us know the iowait times (also from sar) and
promise it's not a Raid5 array you have in use?
(but, admittedly it doesn't explain for a big difference between mysql
and postgresql)

Also, I don't know if I would value RedHat supporting postgre 8.1
higher than running 8.4.1  :)


Florian

-- 
'Sie brauchen sich um Ihre Zukunft keine Gedanken zu machen'

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users