pgsql-server/src backend/executor/nodeHashjoin ...

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl(at)postgresql(dot)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.