Re: ReadRecentBuffer() doesn't scale well - Mailing list pgsql-hackers

From Andres Freund
Subject Re: ReadRecentBuffer() doesn't scale well
Date
Msg-id 20230627062701.5j2ip5dadee2op5p@awork3.anarazel.de
Whole thread Raw
In response to Re: ReadRecentBuffer() doesn't scale well  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: ReadRecentBuffer() doesn't scale well
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Clean up JumbleQuery() from query text
Next
From: Ronan Dunklau
Date:
Subject: Re: Add GUC to tune glibc's malloc implementation.