> > is 2.5 times faster on one commercial database (there are tests on Internet
> > that say 'Postgresql is faster than that database).
> > I can't say which database it is.
> >
>
> The 'order by' statement is redundant since you use already 'group by'.
> Furthermore you can speed up the query by creating an index on your
> 'group by' fields (in this case 'roba').
>
> If one database is faster than the other depends on what you test. I've
> read that PostgreSQL can be slow with queries that contain a group by,
> although I did not experience such thing myself.
Is there a TODO item I can add here folks?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026