Re: Hash index build performance tweak from sorting

From: David Zhang <david(dot)zhang(at)highgo(dot)ca>
To: Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Hash index build performance tweak from sorting
Date: 2022-08-05 19:46:27
Message-ID: 510133a5-527c-5c3b-8801-42205cc87c50@highgo.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 applied patch `hash_inserted_sorted.v2.patch`, I see about ~3% improvement. All the test results are based on 10 times average on two different machines.

Best regards,

--
David

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2022-08-05 20:10:47 Re: BTMaxItemSize seems to be subtly incorrect
Previous Message Stephen Frost 2022-08-05 19:02:12 Re: Proposal: Support custom authentication methods using hooks