Re: Horribly slow hash join - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: Horribly slow hash join
Date
Msg-id Pine.LNX.4.44.0404181825590.4551-100000@zigo.dhs.org
Whole thread Raw
In response to Re: Horribly slow hash join  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Horribly slow hash join  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-performance
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.

--
/Dennis Björklund


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Horribly slow hash join
Next
From: Dave Cramer
Date:
Subject: Re: Toooo many context switches (maybe SLES8?)