]> granicus.if.org Git - postgresql/commit
Extend code that deduces implied equality clauses to detect whether a
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 18 Oct 2001 16:11:42 +0000 (16:11 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 18 Oct 2001 16:11:42 +0000 (16:11 +0000)
commit6254465d0621f724cdc9a1e99da24fa8a29f579d
tree84bd08321ce84de9daf6ab5264c889e5b5a92e4e
parent50450049581566ed47016cd89ba03b90be7ea1d0
Extend code that deduces implied equality clauses to detect whether a
clause being added to a particular restriction-clause list is redundant
with those already in the list.  This avoids useless work at runtime,
and (perhaps more importantly) keeps the selectivity estimation routines
from generating too-small estimates of numbers of output rows.
Also some minor improvements in OPTIMIZER_DEBUG displays.
src/backend/nodes/print.c
src/backend/optimizer/README
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/path/joinrels.c
src/backend/optimizer/path/pathkeys.c
src/backend/optimizer/plan/initsplan.c
src/backend/optimizer/plan/planner.c
src/backend/optimizer/util/relnode.c
src/include/optimizer/paths.h