Hi, On 2022-11-21 16:17:56 -0500, Robert Haas wrote: > But ... what if they're not? Could the index contain a large number of > pages containing just 1 tuple each, or no tuples at all? If so, maybe > we can read ten bazillion index pages trying to find each heap tuple > and still end up in trouble.
ISTM that if you have an index in such a poor condition that a single value lookup reads thousands of pages inside the index, planner estimates taking long is going to be the smallest of your worries... Greetings, Andres Freund
