>
> One little thing. Did you shutdown sql2000 while testing
> postgresql? Remember that postgresql uses system cache.
> Sql2000 uses a large part of memory as buffer and it will not
> be available to operating system. I must say that, probably,
> results will be the same, but it will be a b
> De : Magnus Hagander [mailto:[EMAIL PROTECTED]
> Out of curiosity, what plan do you get from SQLServer? I bet
> it's a clustered index scan...
>
>
> //Magnus
>
I have a Table scan and Hashaggregate...
Stephane
---(end of broadcast)---
TI
ash Aggregate is much better than index scan ...
> >
> >Thanks for help.
> >
> >Stéphane COEZ
> >
> >
> >
> >
> >---(end of
> >broadcast)---
> >TIP 9: In versions below 8.0, the planner will
rows=55 width=8)
-> Index Scan using myindex on mytable (cost=0.00..68429.20 rows=3233927
width=8)
but performance will be comparable to previous test.
So with or without using Index I have the same result.
Thanks for help.
Stéphane COEZ
-
