Re: equivalence class not working?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: uwcssa <uwcssa(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: equivalence class not working?
Date: 2006-01-16 21:46:43
Message-ID: 18394.1137448003@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

uwcssa <uwcssa(at)gmail(dot)com> writes:
> I am using postgres 8.1. In indxpath.c, it says " Note: if Postgres tried
> to optimize queries by forming equivalence
> classes over equi-joined attributes (i.e., if it recognized that
> aqualification such as "where
> a.b=3Dc.d and a.b=3D5" could make use of
> an index on c.d), then we could use that equivalence class info here with
> joininfo_list to do more complete tests for the usability
> of a partial index. ..... XXX as of 7.1, equivalence class info *is*
> available."

Are you deliberately ignoring the rest of the comment?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-01-16 21:49:43 Re: ScanKey representation for RowCompare index conditions
Previous Message Tom Lane 2006-01-16 21:21:50 Re: Anyone see a need for BTItem/HashItem?