"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Could you not just scan right and see what the first key was? Thought > granted, that means there's a chance of a wasted page scan, but I think > that'd be somewhat of a corner case, so it might not be bad.
No, because (a) that confuses the first key that happens to be on a page with its keyspace boundary --- what happens when you need to delete that data key? and (b) because of locking considerations, you don't want to move right and then have to back up. You'd have to hold lock on the first page while reading in the second, which makes for a nontrivial performance hit. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly