From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Nils Zonneveld <nils(at)mbit(dot)nl> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Re: Performance aggregates |
Date: | 2001-05-18 14:37:11 |
Message-ID: | 200105181437.f4IEbBm17766@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Boes | 2001-05-18 14:44:20 | Foreign key constraint generates unique index? |
Previous Message | Stephan Szabo | 2001-05-18 14:34:40 | Re: CVS, initdb and catalog version |