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-0007Lt-Hl@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
------
REL8_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/29d539b35fb9a5c82546918132f9a561c75f14d7

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