git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Fix cost_nestloop and cost_hashjoin to model the behavior of semi and anti

author Tom Lane <tgl@sss.pgh.pa.us>

Sat, 9 May 2009 22:51:41 +0000 (22:51 +0000)

committer Tom Lane <tgl@sss.pgh.pa.us>

Sat, 9 May 2009 22:51:41 +0000 (22:51 +0000)

commit 8dcf18414ba3fd68970fb5095f26bb9f358dedfe

tree 286c9dd55543baf5c7887e7d17dc26c43cd0845b tree

parent a41e9ec0db08dec52be8ee1c27fe55f742e1a8a9 commit | diff

Fix cost_nestloop and cost_hashjoin to model the behavior of semi and anti
joins a bit better, ie, understand the differing cost functions for matched
and unmatched outer tuples. There is more that could be done in cost_hashjoin
but this already helps a great deal. Per discussions with Robert Haas.

src/backend/optimizer/path/costsize.c diff | blob | blame | history

src/backend/optimizer/plan/createplan.c diff | blob | blame | history

src/backend/optimizer/util/restrictinfo.c diff | blob | blame | history

src/include/optimizer/restrictinfo.h diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom