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/backend/nodes/copyfuncs.c | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'src/backend/nodes/copyfuncs.c') diff --git a/src/backend/nodes/copyfuncs.c b/src/backend/nodes/copyfuncs.c index a678d6326b1..7798913cde5 100644 --- a/src/backend/nodes/copyfuncs.c +++ b/src/backend/nodes/copyfuncs.c @@ -15,7 +15,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/nodes/copyfuncs.c,v 1.223 2002/11/25 21:29:36 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/nodes/copyfuncs.c,v 1.224 2002/11/30 00:08:16 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -429,7 +429,6 @@ _copyHashJoin(HashJoin *from) * copy remainder of node */ COPY_NODE_FIELD(hashclauses); - COPY_SCALAR_FIELD(hashjoinop); /* subPlan list must point to subplans in the new subtree, not the old */ FIX_SUBPLAN_LINKS(join.plan.subPlan, hashclauses); @@ -593,9 +592,9 @@ _copyHash(Hash *from) /* * copy remainder of node */ - COPY_NODE_FIELD(hashkey); + COPY_NODE_FIELD(hashkeys); - /* XXX could the hashkey contain subplans? Not at present... */ + /* XXX could the hashkeys contain subplans? Not at present... */ return newnode; } -- cgit v1.2.3