Re: slow get_actual_variable_range with long running transactions

Oh, sorry about that, I forgot to detail this. I tested on both 10.13 (which is the production environment on which we faced this), and on 12.3, with the same problem.

On 16/06/2020 17:51, Tom Lane wrote:
> Marc Cousin <cousinmarc(at)gmail(dot)com> writes:
>> Of course, what happens here is that the histogram says that max(a) is 1000000, and get_actual_variable_range verifies the real upper bound. And has to read quite a few dead index records.
>
> We've revised that logic several times to reduce the scope of the
> problem. Since you didn't say which PG version you're using exactly,
> it's hard to offer any concrete suggestions. But I fear there's
> not a lot you can do about it, other than upgrading if you're on a
> pre-v11 release.
>
> regards, tom lane
>