On 06/07/2010 12:17 PM, Julien wrote: > On Mon, 2010-06-07 at 18:24 +0200, Florian Heigl wrote: >> Hi all, >> >>> Within psql/mysql: >>> 1) select count(*) from File; 1sec 30min >> > > Is your MySQL database in the MyISAM format ? If yes, then it's > perfectly normal. >
Yes. So it sounds like the row count is a red herring in saying there's a performance problem with postgres. I'll try to ignore that result then and concentrate on the queries like the one that produces the "jobs run" in the bat console. That and the "version browser" are where I'm seeing my worst results. >> 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 >> > -- Stephen Thompson Berkeley Seismological Laboratory step...@seismo.berkeley.edu 215 McCone Hall # 4760 404.538.7077 (phone) University of California, Berkeley 510.643.5811 (fax) Berkeley, CA 94720-4760 ------------------------------------------------------------------------------ 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
