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

From Simon Riggs
Subject Re: Hash index build performance tweak from sorting
Date
Msg-id CANbhV-ENo3y+BqJRyjE303QfUYyoASn5A+65FZh56-v6+H-3Mg@mail.gmail.com
Whole thread Raw
In response to Re: Hash index build performance tweak from sorting  (David Zhang <david.zhang@highgo.ca>)
List pgsql-hackers
On Fri, 5 Aug 2022 at 20:46, David Zhang <david.zhang@highgo.ca> wrote:
>
> 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. 

Thanks for testing David.

It's a shame you only see 3%, but that's still worth it.

--
Simon Riggs                http://www.EnterpriseDB.com/



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Reducing the chunk header sizes on all memory context types
Next
From: Nathan Bossart
Date:
Subject: Re: archive modules