Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL
Date
Msg-id 20070512192235.9FF039FB326@postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Improve predicate_refuted_by_simple_clause() to handle IS NULL and IS NOT NULL
more completely.  The motivation for having it understand IS NULL at all was
to allow use of "foo IS NULL" as one of the subsets of a partitioning on
"foo", but as reported by Aleksander Kmetec, it wasn't really getting the job
done.  Backpatch to 8.2 since this is arguably a performance bug.

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        predtest.c (r1.14 -> r1.15)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/predtest.c.diff?r1=1.14&r2=1.15)

pgsql-committers by date:

Previous
From: pgunittest@pgfoundry.org (User Pgunittest)
Date:
Subject: pgunittest - pgUnitTest:
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL