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

On Wed, Jun 24, 2026 at 4:48 AM Jakub Wartak
<jakub.wartak@enterprisedb.com> wrote:
>  #define VISITED_PAGES_LIMIT 100
> +#define INDEX_PAGES_LIMIT 3
>
> So, is this based that proportion that we assume that everywhere on average
> 33 heap pages are going to be covered by 1 btree page? (just asking if we
> I get the assumption right, I don't have anything against it).

No, they're just 2 independent limits. I don't think that you can make
any useful assumptions about the average density of heap pages per
leaf page. There's too much workload diversity for that.

--
Peter Geoghegan