Re: More Hashing questions - Mailing list pgsql-hackers

From Greg Stark
Subject Re: More Hashing questions
Date
Msg-id 87k6zpthwh.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: More Hashing questions  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:

> If you do this I suggest supporting bigint as well.

Well I'm not about to actually do the inter-data-type hash joins. I was just
asking if the hash functions for floats should be adjusted to guarantee this
property. bigints already guarantee it, though I think the hash function can
be improved without breaking it.

> On Tue, May 04, 2004 at 06:45:37PM -0400, Greg Stark wrote:
> > 
> > Regarding inter-data-type hash joins, would it make sense to make float
> > datatypes to hash to the same value as integral data types for integral
> > values?

I have a little patch but I have to test it, at least try to compile it,
before I send it anywhere :)

-- 
greg



pgsql-hackers by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: PostgreSQL pre-fork speedup
Next
From: "Thomas Hallgren"
Date:
Subject: Makefile.shlib functionality on win32