Re: Problems with get_actual_variable_range's VISITED_PAGES_LIMIT - Mailing list pgsql-hackers

On Tue, Jun 23, 2026 at 4:06 PM Peter Geoghegan <pg@bowt.ie> wrote:
> Importantly, this allows VISITED_PAGES_LIMIT to work exactly the same
> way on standbys as it does today. During hot standby, LP_DEAD bits
> cannot be set or used to avoid heap fetches. As long as each leaf page
> returns at least one match (which could still be a TID pointing to a
> dead heap tuple), nothing changes -- INDEX_PAGES_LIMIT does nothing
> new, we rely on VISITED_PAGES_LIMIT in the traditional way.

I attach this patch here, to be tracked as its own CF entry going forward.

I committed "Add slot-based table AM index scan interface" this
morning, which this INDEX_PAGES_LIMIT patch depends on. There's no
longer any reason to tie this patch to the index
prefetching/amgetbatch work.

--
Peter Geoghegan