Re: [HACKERS] hacking postgres hashjoin algorithm

2006-10-20 Thread HS
from my understanding, postgres first needs to partition the tables. ExecHashTableCreate() is the function that partitions the tables right? Martijn van Oosterhout wrote: 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

[HACKERS] hacking postgres hashjoin algorithm

2006-10-17 Thread HS
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 please

Re: [HACKERS] hacking postgres hashjoin algorithm

2006-10-17 Thread Martijn van Oosterhout
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