>>>>> On Mon, 7 Jun 2010 18:24:34 +0200, Florian Heigl said:
> 
> 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.

Is counting all rows ever fast on postgres?  For me, it runs a sequential
scan, which is always slow.  It is probably never done with millions of rows
in a real application, so noone has optimized it.

__Martin

------------------------------------------------------------------------------
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