Обсуждение: pgsql-server/src backend/executor/nodeHashjoin ...

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.