Re: Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support
Дата
Msg-id 162867790912202101v411fb4b9if27a1bc7ab3447fa@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Proposal: Pre ordered aggregates, default ORDER BY clause for aggregates - median support  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
2009/12/21 Greg Stark <gsstark@mit.edu>:
> Incidentally there are O(n) algorithms for finding the median (or any
> specific offset). It shouldn't be necessary to sort at all.

it is interesting information. It could to help with missing
optimalisations now.

Pavel

>
> I'm not sure which path this argues for - perhaps Tom's position that
> we need more optimiser infrastructure so we can see how to accomplish
> this. Perhaps it means you should really implement median() with an
> internal selection alagorithm and not depend on the optimizer at all.
>
>
> --
> greg
>


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Removing pg_migrator limitations
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Possible patch for better index name choosing