On 10/18/14, 12:15 AM, Tom Lane wrote:
> Marko Tiikkaja <marko(at)joh(dot)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