]> granicus.if.org Git - postgresql/commit
Allow the planner to collapse explicit inner JOINs together, rather than
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 25 Jan 2003 23:10:30 +0000 (23:10 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 25 Jan 2003 23:10:30 +0000 (23:10 +0000)
commit9f5f2124754ccd605671bfe952c220b46a0e730b
treee6be6eab43ffe733b9c785d62cec74497098c694
parent15ab7a87206d657a4182d2932970384d540004d0
Allow the planner to collapse explicit inner JOINs together, rather than
necessarily following the JOIN syntax to develop the query plan.  The old
behavior is still available by setting GUC variable JOIN_COLLAPSE_LIMIT
to 1.  Also create a GUC variable FROM_COLLAPSE_LIMIT to control the
similar decision about when to collapse sub-SELECT lists into their parent
lists.  (This behavior existed already, but the limit was always
GEQO_THRESHOLD/2; now it's separately adjustable.)
12 files changed:
doc/src/sgml/perform.sgml
doc/src/sgml/release.sgml
doc/src/sgml/runtime.sgml
src/backend/optimizer/path/allpaths.c
src/backend/optimizer/plan/planner.c
src/backend/optimizer/prep/prepjointree.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/bin/psql/tab-complete.c
src/include/optimizer/paths.h
src/include/optimizer/prep.h
src/test/regress/expected/join.out