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 <mle...@entrata.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. >
