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-0007Lp-El@gemulon.postgresql.org
Views: Raw Message | Whole Thread | 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_0_STABLE

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

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