]> granicus.if.org Git - postgresql/commit
Upgrade cost estimation for joins, per discussion with Bradley Baetz.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 27 Jan 2003 20:51:54 +0000 (20:51 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 27 Jan 2003 20:51:54 +0000 (20:51 +0000)
commit70fba70430bd42b1a31c6d49646f9d1991eb8e7c
tree865c11bc1262e1fd48067f9b897abf2a50653ddf
parentb2773d4099d2dbccc4d23165a093581090c49451
Upgrade cost estimation for joins, per discussion with Bradley Baetz.
Try to model the effect of rescanning input tuples in mergejoins;
account for JOIN_IN short-circuiting where appropriate.  Also, recognize
that mergejoin and hashjoin clauses may now be more than single operator
calls, so we have to charge appropriate execution costs.
src/backend/executor/nodeHashjoin.c
src/backend/executor/nodeNestloop.c
src/backend/nodes/list.c
src/backend/optimizer/path/costsize.c
src/backend/optimizer/path/joinpath.c
src/backend/optimizer/util/pathnode.c
src/backend/utils/adt/selfuncs.c
src/include/nodes/pg_list.h
src/include/optimizer/cost.h
src/test/regress/expected/subselect.out