Re: Memory usage during sorting

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Memory usage during sorting
Дата
Msg-id 26643.1332259957@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Memory usage during sorting  (Greg Stark <stark@mit.edu>)
Ответы Re: Memory usage during sorting
Список pgsql-hackers
Greg Stark <stark@mit.edu> writes:
> http://en.wikipedia.org/wiki/Binary_heap#Building_a_heap

Interesting.  I'm pretty sure that idea appears nowhere in Knuth
(which might mean it's new enough to have a live patent on it ...
anybody know who invented this?).  But it seems like that should buy
back enough comparisons to justify leaving the next-run tuples out of
the heap (unordered) until the heap becomes empty.  You still want to
insert new tuples into the heap if they can go to the current run, of
course.
        regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Regarding column reordering project for GSoc 2012
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Memory usage during sorting