Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL
- From: tgl(at)postgresql(dot)org (Tom Lane)
- To: pgsql-committers(at)postgresql(dot)org
- Subject: pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL
- Date: Sat, 12 May 2007 16:22:43 -0300 (ADT)
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.
Tags:
----
REL8_2_STABLE
Modified Files:
--------------
pgsql/src/backend/optimizer/util:
predtest.c (r1.10 -> r1.10.2.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/predtest.c.diff?r1=1.10&r2=1.10.2.1)
- Prev by Date: pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL
- Next by Date: pgsql: Add: > o Allow data to be passed in native language formats,
- Previous by thread: pgsql: Improve predicate_refuted_by_simple_clause() to handle IS NULL
- Next by thread: pgsql: Add: > o Allow data to be passed in native language formats,
- Indexes: