Andres Freund <and...@anarazel.de> writes: > This can't quite be right - isn't this only applying the limit if we found a > visible tuple?
What it's restricting is the number of heap page fetches, which might be good enough. We don't have a lot of visibility here into how many index pages were scanned before returning the next not-dead index entry, so I'm not sure how hard it'd be to do better. regards, tom lane