Re: TODO items

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
>>> * Use index to restrict rows returned by multi-key index when used with
>>> non-consecutive keys or OR clauses, so fewer heap accesses
>>
>> Not sure what this means.

> This is a Vadim idea. The idea was that if you had a multi-key index on
> col1,col2,col3, and you wanted to do a lookup on col1,col3, you could
> still use the index, and just run through all the matching col1 values
> looking for a matching col3 in the index, rather than going to the heap
> and looking for a col3 match? Is this item worth keeping?

Hmm. Maybe. Might as well leave it there awhile longer.

regards, tom lane