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>
Re: Minor performance improvement in transition to external sort Robert Haas <robertmhaas@gmail.com>
Re: Minor performance improvement in transition to external sort Jeremy Harris <jgh@wizmail.org>
Re: Minor performance improvement in transition to external sort Robert Haas <robertmhaas@gmail.com>
Re: Minor performance improvement in transition to external sort Jeremy Harris <jgh@wizmail.org>
Re: Minor performance improvement in transition to external sort Michael Paquier <michael.paquier@gmail.com>
Re: Minor performance improvement in transition to external sort Jeff Janes <jeff.janes@gmail.com>
Re: Minor performance improvement in transition to external sort Jeremy Harris <jgh@wizmail.org>
Re: Minor performance improvement in transition to external sort Jeremy Harris <jgh@wizmail.org>
Re: Minor performance improvement in transition to external sort Robert Haas <robertmhaas@gmail.com>
Re: Minor performance improvement in transition to external sort Jeremy Harris <jgh@wizmail.org>
Re: Minor performance improvement in transition to external sort Jeremy Harris <jgh@wizmail.org>
Re: Minor performance improvement in transition to external sort Robert Haas <robertmhaas@gmail.com>
Re: Minor performance improvement in transition to external sort Jeremy Harris <jgh@wizmail.org>
Re: Minor performance improvement in transition to external sort Robert Haas <robertmhaas@gmail.com>
Re: Minor performance improvement in transition to external sort Jeremy Harris <jgh@wizmail.org>
Re: Minor performance improvement in transition to external sort Simon Riggs <simon@2ndQuadrant.com>
Re: Minor performance improvement in transition to external sort Bruce Momjian <bruce@momjian.us>
Re: Minor performance improvement in transition to external sort Robert Haas <robertmhaas@gmail.com>
On Wed, Feb 5, 2014 at 7:22 AM, Jeremy Harris  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
Дата:
От: Michael Paquier
Дата:
FAQ