Re: More Hashing questions

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: More Hashing questions
Date: 2004-05-06 20:33:34
Message-ID: 87k6zpthwh.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Jim C. Nasby" <jim(at)nasby(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Hallgren 2004-05-06 21:11:29 Makefile.shlib functionality on win32
Previous Message scott.marlowe 2004-05-06 19:30:59 Re: PostgreSQL pre-fork speedup