From 25442d8d2fd35389813062f523488821f4fc31d4 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 18 Apr 2000 05:43:02 +0000 Subject: Correct oversight in hashjoin cost estimation: nodeHash sizes its hash table for an average of NTUP_PER_BUCKET tuples/bucket, but cost_hashjoin was assuming a target load of one tuple/bucket. This was causing a noticeable underestimate of hashjoin costs. --- src/backend/executor/nodeHash.c | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) (limited to 'src/backend/executor') diff --git a/src/backend/executor/nodeHash.c b/src/backend/executor/nodeHash.c index bee4a10f35..1d841576fe 100644 --- a/src/backend/executor/nodeHash.c +++ b/src/backend/executor/nodeHash.c @@ -7,7 +7,7 @@ * Portions Copyright (c) 1994, Regents of the University of California * * - * $Id: nodeHash.c,v 1.44 2000/01/26 05:56:22 momjian Exp $ + * $Id: nodeHash.c,v 1.45 2000/04/18 05:43:01 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -221,7 +221,6 @@ ExecEndHash(Hash *node) * create a hashtable in shared memory for hashjoin. * ---------------------------------------------------------------- */ -#define NTUP_PER_BUCKET 10 #define FUDGE_FAC 2.0 HashJoinTable -- cgit v1.2.1