Re: Additional select fields in a GROUP BY

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Additional select fields in a GROUP BY
Дата
Msg-id 21366.1087097995@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Additional select fields in a GROUP BY  (Vitaly Belman <vitalib@012.net.il>)
Список pgsql-performance
Vitaly Belman <vitalib@012.net.il> writes:
> The problem is that addind them all to GROUP BY causes a performance
> loss.

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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Vitaly Belman
Дата:
Сообщение: Additional select fields in a GROUP BY
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Additional select fields in a GROUP BY