| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | uwcssa <uwcssa(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: equivalence class not working? |
| Date: | 2006-01-18 08:46:34 |
| Message-ID: | 1137573994.3180.328.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2006-01-18 09:51:44 | Re: Bad estimate on LIKE matching |
| Previous Message | Simon Riggs | 2006-01-18 08:08:00 | Re: Bad estimate on LIKE matching |