CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: [EMAIL PROTECTED] 04/01/05 19:39:54
Modified files:
src/backend/nodes: outfuncs.c
src/backend/optimizer/path: costsize.c indxpath.c orindxpath.c
src/backend/optimizer/plan: createplan.c
src/backend/optimizer/util: pathnode.c restrictinfo.c
src/backend/utils/adt: selfuncs.c
src/include/nodes: relation.h
src/include/optimizer: paths.h restrictinfo.h
Log message:
Adjust indexscan planning logic to keep RestrictInfo nodes associated
with index qual clauses in the Path representation. This saves a little
work during createplan and (probably more importantly) allows reuse of
cached selectivity estimates during indexscan planning. Also fix latent
bug: wrong plan would have been generated for a 'special operator' used
in a nestloop-inner-indexscan join qual, because the special operator
would not have gotten into the list of quals to recheck. This bug is
only latent because at present the special-operator code could never
trigger on a join qual, but sooner or later someone will want to do it.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
