Re: Hash index build performance tweak from sorting

Simon Riggs <simon.riggs@enterprisedb.com>

View thread View on postgr.es

From: Simon Riggs <simon.riggs@enterprisedb.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Amit Kapila <amit.kapila16@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2022-07-28T12:47:10Z

Lists: pgsql-hackers

Attachments

hash_sort_by_hash.v3.patch (application/octet-stream) patch v3

On Wed, 27 Jul 2022 at 19:22, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Simon Riggs <simon.riggs@enterprisedb.com> writes:
> > [ hash_sort_by_hash.v2.patch ]
>
> The cfbot says this no longer applies --- probably sideswiped by
> Korotkov's sorting-related commits last night.

Thanks for the nudge. New version attached.

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

Commits

Speedup hash index builds by skipping needless binary searches
- d09dbeb9bde6 16.0 landed
Improve speed of hash index build.
- e09d7a1262c6 16.0 landed
Change hash indexes to store only the hash code rather than the whole indexed
- 4adc2f72a4cc 8.4.0 cited