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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
