git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Upgrade cost estimation for joins, per discussion with Bradley Baetz.

author Tom Lane <tgl@sss.pgh.pa.us>

2003年1月27日 20:51:54 +0000 (20:51 +0000)

committer Tom Lane <tgl@sss.pgh.pa.us>

2003年1月27日 20:51:54 +0000 (20:51 +0000)

commit 70fba70430bd42b1a31c6d49646f9d1991eb8e7c

tree 865c11bc1262e1fd48067f9b897abf2a50653ddf tree

parent b2773d4099d2dbccc4d23165a093581090c49451 commit | diff

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 diff | blob | blame | history

src/backend/executor/nodeNestloop.c diff | blob | blame | history

src/backend/nodes/list.c diff | blob | blame | history

src/backend/optimizer/path/costsize.c diff | blob | blame | history

src/backend/optimizer/path/joinpath.c diff | blob | blame | history

src/backend/optimizer/util/pathnode.c diff | blob | blame | history

src/backend/utils/adt/selfuncs.c diff | blob | blame | history

src/include/nodes/pg_list.h diff | blob | blame | history

src/include/optimizer/cost.h diff | blob | blame | history

src/test/regress/expected/subselect.out diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom