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)
Список
Дерево обсуждения
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 по дате отправления