pgsql: Prefer actual constants to pseudo-constants in equivalence class

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Prefer actual constants to pseudo-constants in equivalence class
Date: 2012-10-26 18:20:54
Message-ID: E1TRoWc-0007Ll-Da@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Prefer actual constants to pseudo-constants in equivalence class machinery.

generate_base_implied_equalities_const() should prefer plain Consts over
other em_is_const eclass members when choosing the "pivot" value that
all the other members will be equated to. This makes it more likely that
the generated equalities will be useful in constraint-exclusion proofs.
Per report from Rushabh Lathia.

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/ff8f7103b559d8f19731157aca38650a938fedef

Modified Files
--------------
src/backend/optimizer/path/equivclass.c | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Kevin Grittner 2012-10-26 20:01:54 pgsql: Throw error if expiring tuple is again updated or deleted.
Previous Message Tom Lane 2012-10-26 16:13:16 pgsql: In pg_dump, dump SEQUENCE SET items in the data not pre-data sec