Minor performance improvement in transition to external sort - Mailing list pgsql-hackers

From Jeremy Harris
Subject Minor performance improvement in transition to external sort
Date
Msg-id 52F16843.8080001@wizmail.org
Whole thread Raw
Responses Re: Minor performance improvement in transition to external sort  (Michael Paquier <michael.paquier@gmail.com>)
Re: Minor performance improvement in transition to external sort  (Robert Haas <robertmhaas@gmail.com>)
Re: Minor performance improvement in transition to external sort  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
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)).

--
Cheers,
    Jeremy

Attachment

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: integrate pg_upgrade analyze_new_cluster.sh into vacuumdb
Next
From: Tom Lane
Date:
Subject: Re: narwhal and PGDLLIMPORT