(My quick and dirty patch posted there still compiles and works, if you would like to test that it fixes the problem for you.)
Because the number of rows is vastly overestimated, so is the cost. Which then causes JIT to kick in counter-productively, due to the deranged cost exceeding jit_above_cost.
Cheers,
Jeff
Hi Jeff,
I tried applying your original patch and the later patch from that thread to REL_12_STABLE, unfortunately no luck on either. The original patch errors with:
error: src/backend/utils/adt/array_typanalyze.c: already exists in working directory
The other with:
$ git apply -p1 < array_typanalyze_0_mce.patch error: src/backend/utils/adt/array_typanalyze.c: already exists in working directory error: src/backend/utils/cache/lsyscache.c: already exists in working directory
I am happy to review and test patches that address this particular issue. Thanks,