Re: hacking postgres hashjoin algorithm - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: hacking postgres hashjoin algorithm
Date
Msg-id 20061017153617.GB12030@svana.org
Whole thread Raw
In response to hacking postgres hashjoin algorithm  (HS <j8shen@gmail.com>)
Responses Re: hacking postgres hashjoin algorithm  (HS <j8shen@gmail.com>)
List pgsql-hackers
On Sun, Oct 15, 2006 at 11:08:18PM -0400, HS wrote:
> Hello there
>
> I am trying to play around with the hashjoin algorithm in postgres.
>
> I am using the statement like
> Select count(*) from r,s where r.id=s.id;
>
> I looked at the function ExecHashJoin() in nodeHashjoin.c and cannot
> find where the algorithm is comparing if r.id equals s.id

The code doing the work is actually ExecScanHashBucket() which is in
nodeHash.c. The actual check is done by the ExecQual there...

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: "Mark Woodward"
Date:
Subject: Syntax bug? Group by?
Next
From: Stephen Frost
Date:
Subject: Re: Syntax bug? Group by?