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/