Re: Minor performance improvement in transition to external sort

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Minor performance improvement in transition to external sort
Дата
Msg-id CAB7nPqSAFzHju9FYzw1sUcuAn8xMVhnv5VW_iM6OOL-0xMX+cg@mail.gmail.com
обсуждение исходный текст
Ответ на Minor performance improvement in transition to external sort  (Jeremy Harris <jgh@wizmail.org>)
Список pgsql-hackers
On Wed, Feb 5, 2014 at 7:22 AM, Jeremy Harris <jgh@wizmail.org> wrote:
> The attached patch replaces the existing siftup method for heapify with
> a siftdown method. Tested with random integers it does 18% fewer
> compares and takes 10% less time for the heapify, over the work_mem
> range 1024 to 1048576.
>
> Both algorithms appear to be O(n) (contradicting Wikipedia's claim
> that a siftup heapify is O(n log n)).
It looks interesting but it is too late to have that in 9.4... You
should definitely add this patch to the next commit fest so as it is
not lost in the void:
https://commitfest.postgresql.org/action/commitfest_view?id=22
Regards,
-- 
Michael



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: should we add a XLogRecPtr/LSN SQL type?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: should we add a XLogRecPtr/LSN SQL type?