Hi, On 2023-06-26 21:53:12 -0700, Peter Geoghegan wrote: > It should be safe to allow searchers to see a version of the root page > that is out of date. The Lehman & Yao design is very permissive about > these things. There aren't any special cases where the general rules > are weakened in some way that might complicate this approach. > Searchers need to check the high key to determine if they need to move > right -- same as always.
Wouldn't we at least need a pin on the root page, or hold a snapshot, to defend against page deletions? Greetings, Andres Freund
