Bruce Momjian <[EMAIL PROTECTED]> writes: > I am thinking we are best just doing the index chain we already have to > read.
> If you are modifying the table (like with UPDATE) it makes sense to be > more aggressive and do the whole page because you know there are > probably other table modifications, but for an index lookup there isn't > any knowledge of whether the table is being modified so looking at more > than we need seems like overkill. Uh, why would any of this code at all execute during a pure lookup? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend