Vitaly Belman <vitalib(at)012(dot)net(dot)il> writes:
> The problem is that addind them all to GROUP BY causes a performance
Really? I'd think that there'd be no visible loss if the earlier
fields of the GROUP BY are already unique. The sort comparison
should stop at the first field that determines the sort order.
Can you provide a self-contained example?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Bruno Wolff III||Date: 2004-06-13 13:52:12|
|Subject: Re: Additional select fields in a GROUP BY|
|Previous:||From: Vitaly Belman||Date: 2004-06-13 03:21:17|
|Subject: Additional select fields in a GROUP BY|