Oh, sorry about that, I forgot to detail this. I tested on both 10.13 (which is the production environment on which we
facedthis), and on 12.3, with the same problem.
On 16/06/2020 17:51, Tom Lane wrote:
> Marc Cousin <cousinmarc@gmail.com> writes:
>> Of course, what happens here is that the histogram says that max(a) is 1000000, and get_actual_variable_range
verifiesthe 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
>