Re: get_actual_variable_range vs idx_scan/idx_tup_fetch - Mailing list pgsql-hackers

On 10/18/14, 12:15 AM, Tom Lane wrote:
> Marko Tiikkaja <marko@joh.to> writes:
>> I think there's a big difference between "this index was used to look up
>> stuff for planning" and "this index was used to answer queries quickly".
>
> I think that's utter nonsense.

Well you probably know a bit more about the optimizer than I do.  But I 
can't see a case where the stats provided by the index would be useful 
for choosing between two (or more) plans that don't use the index in the 
actual query.  If you're saying that there are such cases, then clearly 
I don't know something, and my thinking is in the wrong here.


.marko