Bruce Momjian <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])