Re: wip: functions median and percentile

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: wip: functions median and percentile
Дата
Msg-id 4308.1282231993@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: wip: functions median and percentile  (Greg Stark <gsstark@mit.edu>)
Ответы Re: wip: functions median and percentile  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> On Thu, Aug 19, 2010 at 11:59 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> I am sending a prototype implementation of functions median and
>> percentile. This implementation is very simple and I moved it to
>> contrib for this moment - it is more easy maintainable. Later I'll
>> move it to core.

> So if the entire result set fits in memory it would be nice to use the
> O(n) Quickselect algorithm -- which would only be a small change to
> the existing Quicksort code -- instead of sorting the entire set.

That seems like rather a lot of added infrastructure for functions whose
popularity is at best unknown.  I think we should KISS for the first
implementation.
        regards, tom lane


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

Предыдущее
От: darklow
Дата:
Сообщение: FTS wildcard and custom ispell dictionary problem
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: refactoring comment.c