Hi Justin, I'm seeing no difference in the query plan with JIT disabled in 12.1.
Thanks, Shira On Mon, Jan 13, 2020 at 8:42 AM Justin Pryzby <pry...@telsasoft.com> wrote: > On Mon, Jan 13, 2020 at 08:29:05AM -0800, Shira Bezalel wrote: > > Here is the EXPLAIN (ANALYZE ON, BUFFERS ON) output from both systems: > > > > 9.6 plan <https://explain.depesz.com/s/W8HN> > > 12.1 plan <https://explain.depesz.com/s/lIRS> > > > Is there something that was changed/improved in either 10, 11 or 12 that > this > > behavior can be attributed to? > > v12 has JIT enabled by default. > You can test if that's significant with SET jit=off. > -- Shira Bezalel Database Administrator & Desktop Support Manager San Francisco Estuary Institute www.sfei.org Ph: 510-746-7304