Re: Hash index build performance tweak from sorting - Mailing list pgsql-hackers

From David Zhang
Subject Re: Hash index build performance tweak from sorting
Date
Msg-id 510133a5-527c-5c3b-8801-42205cc87c50@highgo.ca
Whole thread Raw
In response to Re: Hash index build performance tweak from sorting  (Simon Riggs <simon.riggs@enterprisedb.com>)
Responses Re: Hash index build performance tweak from sorting
List pgsql-hackers
On 2022-08-01 8:37 a.m., Simon Riggs wrote:
> Using the above test case, I'm getting a further 4-7% improvement on
> already committed code with the attached patch, which follows your
> proposal.

I ran two test cases: for committed patch `hash_sort_by_hash.v3.patch`, I can see about 6 ~ 7% improvement; and after
appliedpatch `hash_inserted_sorted.v2.patch`, I see about ~3% improvement. All the test results are based on 10 times
averageon two different machines.
 

Best regards,

-- 
David

Software Engineer
Highgo Software Inc. (Canada)
www.highgo.ca



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Proposal: Support custom authentication methods using hooks
Next
From: Peter Geoghegan
Date:
Subject: Re: BTMaxItemSize seems to be subtly incorrect