Re: Slow SQL lookup due to every field being listed in SORT KEY

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Slow SQL lookup due to every field being listed in SORT KEY
Дата
Msg-id 20100911020337.GH26232@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Slow SQL lookup due to every field being listed in SORT KEY  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Slow SQL lookup due to every field being listed in SORT KEY  (Mason Harding <mason.harding@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> The reason it's sorting by all the columns is the DISTINCT

You might also verify that you actually need/*should* have the DISTINCT,
if it's included today..  Often developers put that in without
understanding why they're getting dups (which can often be due to
missing pieces from the JOIN clause or misunderstanding of the database
schema...).

    Stephen
Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow SQL lookup due to every field being listed in SORT KEY
Следующее
От:
Дата:
Сообщение: Problem with mergejoin performance