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

git projects / postgresql.git / commit

Marginal improvement in sublink planning: allow unknownEqFalse optimization

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

2008年8月20日 19:58:24 +0000 (19:58 +0000)

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

2008年8月20日 19:58:24 +0000 (19:58 +0000)

commit cc0dd438508d579cf9999304f4c8a8f4951410e1

tree 65e3896eaf3cb0f4a5eb9121201b4cc4f9e7e37e tree

parent 3c35de85e7b23f1152a069f9f8508d7fca270704 commit | diff

Marginal improvement in sublink planning: allow unknownEqFalse optimization
to be used for SubLinks that are underneath a top-level OR clause. Just as at
the very top level of WHERE, it's not necessary to be accurate about whether
the sublink returns FALSE or NULL, because either result has the same impact
on whether the WHERE will succeed.

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

This is the main PostgreSQL git repository.

RSS Atom