pgsql-server/src backend/nodes/copyfuncs.c bac ...

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl(at)postgresql(dot)org 02/11/24 16:52:15

Modified files:
src/backend/nodes: copyfuncs.c equalfuncs.c list.c outfuncs.c
readfuncs.c
src/backend/optimizer/path: indxpath.c joinpath.c orindxpath.c
tidpath.c
src/backend/optimizer/plan: initsplan.c
src/backend/optimizer/util: pathnode.c plancat.c relnode.c
restrictinfo.c
src/include/nodes: nodes.h pg_list.h relation.h
src/include/optimizer: paths.h restrictinfo.h

Log message:
Restructure planning of nestloop inner indexscans so that the set of usable
joinclauses is determined accurately for each join. Formerly, the code only
considered joinclauses that used all of the rels from the outer side of the
join; thus for example
FROM (a CROSS JOIN b) JOIN c ON (c.f1 = a.x AND c.f2 = b.y)
could not exploit a two-column index on c(f1,f2), since neither of the
qual clauses would be in the joininfo list it looked in. The new code does
this correctly, and also is able to eliminate redundant clauses, thus fixing
the problem noted 24-Oct-02 by Hans-Jrgen Schnig.