Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Teach find_nonnullable_rels to handle OR cases: if every arm of - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Teach find_nonnullable_rels to handle OR cases: if every arm of
Date
Msg-id 20070216233208.89BEA9FB48D@postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Teach find_nonnullable_rels to handle OR cases: if every arm of an OR
forces a particular relation nonnullable, then we can say that the OR does.
This is worth a little extra trouble since it may allow reduction of
outer joins to plain joins.

Modified Files:
--------------
    pgsql/src/backend/optimizer/util:
        clauses.c (r1.233 -> r1.234)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/util/clauses.c.diff?r1=1.233&r2=1.234)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Add: > o Consider reducing on-disk varlena length from four to
Next
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Create AVG() aggregates for int8 and NUMERIC which do not compute