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-0007Lh-AR@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
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/17804fa71b4a4e7a099f780616a7b53ea591774d

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