From ddb2d78de0172b1f3a00c8e3bf35345af9952f43 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 30 Nov 2002 00:08:22 +0000 Subject: Upgrade planner and executor to allow multiple hash keys for a hash join, instead of only one. This should speed up planning (only one hash path to consider for a given pair of relations) as well as allow more effective hashing, when there are multiple hashable joinclauses. --- src/include/nodes/execnodes.h | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'src/include/nodes/execnodes.h') diff --git a/src/include/nodes/execnodes.h b/src/include/nodes/execnodes.h index 6ee39b9818..544510746d 100644 --- a/src/include/nodes/execnodes.h +++ b/src/include/nodes/execnodes.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: execnodes.h,v 1.80 2002/11/25 21:29:42 tgl Exp $ + * $Id: execnodes.h,v 1.81 2002/11/30 00:08:20 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -618,7 +618,8 @@ typedef struct MergeJoinState * tuple, or NULL if starting search * (CurBucketNo and CurTuple are meaningless * unless OuterTupleSlot is nonempty!) - * hj_InnerHashKey the inner hash key in the hashjoin condition + * hj_OuterHashKeys the outer hash keys in the hashjoin condition + * hj_InnerHashKeys the inner hash keys in the hashjoin condition * hj_OuterTupleSlot tuple slot for outer tuples * hj_HashTupleSlot tuple slot for hashed tuples * hj_NullInnerTupleSlot prepared null tuple for left outer joins @@ -633,7 +634,8 @@ typedef struct HashJoinState HashJoinTable hj_HashTable; int hj_CurBucketNo; HashJoinTuple hj_CurTuple; - Node *hj_InnerHashKey; + List *hj_OuterHashKeys; + List *hj_InnerHashKeys; TupleTableSlot *hj_OuterTupleSlot; TupleTableSlot *hj_HashTupleSlot; TupleTableSlot *hj_NullInnerTupleSlot; -- cgit v1.2.1