Re: equivalence class not working? - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: equivalence class not working?
Date
Msg-id 1137573994.3180.328.camel@localhost.localdomain
Whole thread Raw
In response to Re: equivalence class not working?  (uwcssa <uwcssa@gmail.com>)
List pgsql-hackers
On Mon, 2006-01-16 at 19:03 -0500, uwcssa wrote:
> Fine. The rest documentation says:" For now, the test only uses
> restriction clauses (those in restrictinfo_list). --Nels, Dec '92",
> however, I understand it as being overridden by the
> followup, which is:"XXX as of 7.1, equivalence class info *is*
> available.  Consider
> improving this code as foreseen by Nels."

All readers are invited to solve the problem.

Currently we add only implied equality conditions, so enhancing the
optimizer to cope with inequalities seems possible.

Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Bad estimate on LIKE matching
Next
From: "Magnus Hagander"
Date:
Subject: Re: Bad estimate on LIKE matching