Re: Hash joins vs small-integer join values - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Hash joins vs small-integer join values
Date
Msg-id 87zm3kxrg0.fsf@oxford.xeocode.com
Whole thread Raw
In response to Hash joins vs small-integer join values  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Hash joins vs small-integer join values
List pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> The best idea I can come up with for the back branches is
> to make ExecHashGetBucketAndBatch do hash_any internally, say

hashany of a 4-byte value degenerates to pretty much just a call to mix().
Perhaps we should just expose a hash12() that takes three integers and calls
mix() on them like hash_any does.

The reason I'm thinking that is that we'll want to do the same thing for
bigint, float4, float8, etc.

And that fix you committed a while back to improve the catcache hash function
made a huge difference. Now I'm wondering if it shouldn't just be invoking
hash_any() or mix() too.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Hash joins vs small-integer join values
Next
From: Tom Lane
Date:
Subject: Re: Hash joins vs small-integer join values