On Fri, Oct 03, 2003 at 17:32:22 -0600,
Kathy Zhu <Kathy.Zhu@Sun.COM> wrote:
> I did a vacuum and got the same result.
> I think the problem lies in there is swapping going for groupby when there is a
> large number of rows in the table, 5000 in this case.
>
> I guess I have to use group by with caution.
In 7.4 you will probably find the results more compatible.
For 7.3 and lower, the first case will use a sort to do a group by.
No sort will be done in the second example.
In 7.4 the groub by will use the new hash aggregate method and will
probably be significantly faster than the second way of doing things.