pgsql-server/ oc/src/sgml/release.sgml rc/back ...

I have marked IN/NOT IN performance problem as fixed in 7.4! Great job.

---------------------------------------------------------------------------

Tom Lane wrote:

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: tgl@postgresql.org 03/01/20 13:55:08

Modified files:
doc/src/sgml : release.sgml
src/backend/executor: nodeHashjoin.c nodeMergejoin.c
nodeNestloop.c
src/backend/nodes: copyfuncs.c equalfuncs.c list.c outfuncs.c
src/backend/optimizer: README
src/backend/optimizer/geqo: geqo_eval.c geqo_main.c
src/backend/optimizer/path: allpaths.c costsize.c indxpath.c
joinpath.c joinrels.c
src/backend/optimizer/plan: createplan.c initsplan.c planmain.c
planner.c setrefs.c subselect.c
src/backend/optimizer/prep: Makefile prepunion.c
src/backend/optimizer/util: clauses.c joininfo.c pathnode.c
relnode.c tlist.c var.c
src/backend/rewrite: rewriteManip.c
src/backend/utils/adt: selfuncs.c
src/include/nodes: nodes.h parsenodes.h pg_list.h relation.h
src/include/optimizer: joininfo.h pathnode.h planmain.h
planner.h prep.h subselect.h tlist.h
var.h
src/include/utils: selfuncs.h
src/test/regress/expected: subselect.out
Added files:
src/backend/optimizer/prep: prepjointree.c

Log message:
IN clauses appearing at top level of WHERE can now be handled as joins.
There are two implementation techniques: the executor understands a new
JOIN_IN jointype, which emits at most one matching row per left-hand row,
or the result of the IN's sub-select can be fed through a DISTINCT filter
and then joined as an ordinary relation.
Along the way, some minor code cleanup in the optimizer; notably, break
out most of the jointree-rearrangement preprocessing in planner.c and
put it in a new file prep/prepjointree.c.

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073