X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4A659D1EC90 for ; Mon, 19 Apr 2004 00:12:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 17503-05 for ; Mon, 19 Apr 2004 00:12:12 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 414DDD1B49B for ; Mon, 19 Apr 2004 00:12:06 -0300 (ADT) Received: (qmail 1925 invoked by uid 500); 19 Apr 2004 03:15:54 -0000 Date: Sun, 18 Apr 2004 22:15:54 -0500 From: Bruno Wolff III To: Dennis Bjorklund Cc: Tom Lane , "Jim C. Nasby" , pgsql-performance@postgresql.org Subject: Re: Horribly slow hash join Message-ID: <20040419031554.GA1881@wolff.to> Mail-Followup-To: Dennis Bjorklund , Tom Lane , "Jim C. Nasby" , pgsql-performance@postgresql.org References: <20084.1082305419@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/257 X-Sequence-Number: 6557 On Sun, Apr 18, 2004 at 18:27:09 +0200, Dennis Bjorklund 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.