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 <cousinm...@gmail.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 >
signature.asc
Description: OpenPGP digital signature
