pgsql: Marginal improvement in sublink planning: allow unknownEqFalse

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Marginal improvement in sublink planning: allow unknownEqFalse
Date: 2008-08-20 19:58:24
Message-ID: 20080820195824.3A0F9755315@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
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.

Modified Files:
--------------
pgsql/src/backend/optimizer/plan:
subselect.c (r1.136 -> r1.137)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/subselect.c?r1=1.136&r2=1.137)

Browse pgsql-committers by date

  From Date Subject
Next Message User Kpierno 2008-08-20 20:39:59 pgstatspack - pgstatspack: New sample report with the new report
Previous Message Bruce Momjian 2008-08-20 18:22:28 pgsql: Remove tools and documention for generating TODO.html.