pgsql-server/src backend/executor/nodeHashjoin ...
pgsql-server/src backend/executor/nodeHashjoin ...
От:
tgl@postgresql.org (Tom Lane)
Дата:
CVSROOT: /cvsroot Module name: pgsql-server Changes by: tgl@postgresql.org 03/01/27 15:51:54 Modified files: src/backend/executor: nodeHashjoin.c nodeNestloop.c src/backend/nodes: list.c src/backend/optimizer/path: costsize.c 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 Log message: 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.