Hiroshi Inoue <[EMAIL PROTECTED]> writes: > Dead(HEAP_XMAX_COMMITTED || HEAP_XMIN_INVALID) tuples never > revive. Live (not dead) tuples never die in Share Lock mode. Hmm ... so you're relying on the ShareLock to ensure that the state of the tuple can't change between when heap_fetch checks it and when nbtree looks at it. Okay, but put in some comments documenting what this stuff is doing and why. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])