From: Bruno Wolff III <bruno@wolff.to>
To: Dennis Bjorklund <db@zigo.dhs.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jim C. Nasby <jim@nasby.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Horribly slow hash join
Date: Sun, 18 Apr 2004 22:15:54 -0500
Message-ID: <20040419031554.GA1881@wolff.to> (raw)
In-Reply-To: <Pine.LNX.4.44.0404181825590.4551-100000@zigo.dhs.org>
References: <20084.1082305419@sss.pgh.pa.us>
<Pine.LNX.4.44.0404181825590.4551-100000@zigo.dhs.org>
On Sun, Apr 18, 2004 at 18:27:09 +0200,
Dennis Bjorklund <db@zigo.dhs.org> wrote:
> On Sun, 18 Apr 2004, Tom Lane wrote:
>
> > > What do you mean? int8 is supported on all platformas
> >
> > No it isn't.
>
> So on platforms where it isn't you would use int4 as the biggest int then.
> I don't really see that as a problem. As long as you calculate the hash on
> the biggest int on that platform it should work.
Another option would be to put the numbers into two int4s. For int4 or
smaller types one of these would be zero. int8s would be split between
the two. The hash function would then be defined on the two int4s.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bruno@wolff.to, db@zigo.dhs.org, tgl@sss.pgh.pa.us, jim@nasby.net
Subject: Re: Horribly slow hash join
In-Reply-To: <20040419031554.GA1881@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox