Re: [PATCHES] hash join: probe both inputs first

2005-06-15 Thread Neil Conway
Neil Conway wrote: Per earlier discussion on pgsql-hackers[1], this patch changes the implementation of hash join to attempt to avoid redundant work if either of the join relations are empty. Applied. -Neil ---(end of broadcast)--- TIP 6: Have

[PATCHES] hash join: probe both inputs first

2005-06-13 Thread Neil Conway
Per earlier discussion on pgsql-hackers[1], this patch changes the implementation of hash join to attempt to avoid redundant work if either of the join relations are empty. The logic is: (1) if the inner relation's startup cost is less than the outer relation's startup cost and this is not an