]> granicus.if.org Git - postgresql/commit
Correct oversight in hashjoin cost estimation: nodeHash sizes its hash
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 18 Apr 2000 05:43:02 +0000 (05:43 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 18 Apr 2000 05:43:02 +0000 (05:43 +0000)
commit25442d8d2fd35389813062f523488821f4fc31d4
treed58f9ec0b5a7d3074c222008a9d58d5c35db5251
parent24864d048eec2c579346eb31a42c87be1c92644e
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
src/backend/optimizer/path/costsize.c
src/include/executor/nodeHash.h