Hi Peter, I'm copying you because I found this while checking when an index-only scan takes the heap page predicate lock in your index prefetching patch. The race also occurs on master without prefetching. Would you have a look at the ordering in v4? At SERIALIZABLE, the scan rechecks the all-visible bit after PredicateLockPage(). On the write side, heap_delete() and heap_update() check for conflicts again after clearing the bit, before they unlock the heap buffer.
Regards, Rui
v4-0001-Fix-SSI-conflicts-between-index-only-scans-and-heap-writes.patch
Description: Binary data
