Re: Seeking reason behind performance gain in 12 with HashAggregate
Justin Pryzby <[email protected]> Mon, 13 Jan 2020 10:42:20 -0600
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <[email protected]> |
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.