Does not seem to improve if I turn off JIT.
# show jit;
on
# explain analyze SELECT tc.table_name, ...
Planning Time: 8.806 ms
Execution Time: 511.249 ms
# set jit=false;
# show jit;
off
# explain analyze SELECT tc.table_name, ...
Planning Time: 8.980 ms
Execution Time: 506.016 ms
On Wed, Feb 26, 2020 at 8:41 AM Michael Lewis <mlewis(at)entrata(dot)com> wrote:
> Have you tried with JIT turned off in PG12? The long running node
> is ProjectSet type which is related to set returning functions. If that is
> getting evaluated differently in PG12, that may be issue.
>