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
stephen AT seismo.berkeley DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users