Heikki Linnakangas <[EMAIL PROTECTED]> writes: > The point remains, however. A page won't get deleted while a scan > might still be interested in it, because deleted pages are not > immediately recycled (except on vacuum full), and the left and right > sibling pointers stay intact until no transaction can be interested in it.
Right. AFAICS there isn't any assumption there that isn't already made by indexscans, since we drop pin before moving to the adjacent page anyway. You still have to be prepared to deal with the same situations. (The new assumption is that index items won't be moved onto a pre-existing right sibling page; the old scan logic didn't assume that.) Heikki, were you planning to make a round of revisions in the patch, or is this as far as you wanted to take it? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org