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@xxxxxxxxxxx> 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.
