Re: Query question

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Query question
Дата
Msg-id 87llqjj5n0.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на Re: Query question  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Query question  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Query question  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> The only thing you're adding to the query is a second SORT step, so it
> shouldn't require any more time/memory than the query's first SORT
> did.

Interesting -- I wonder if it would be possible for the optimizer to
detect this and avoid the redundant inner sort ... (/me muses to
himself)

-Neil


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

Предыдущее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: Seeking help with a query that takes too long
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: Seeking help with a query that takes too long