| From: | Shira Bezalel <shira(at)sfei(dot)org> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Seeking reason behind performance gain in 12 with HashAggregate |
| Date: | 2020-01-13 17:34:04 |
| Message-ID: | CAE0KEwF-TZvn-Uar68Vem_jrKxoS=bzxmaBmxmFKFQ555-rg5Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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 <pryzby(at)telsasoft(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Lewis | 2020-01-13 18:07:16 | Re: Seeking reason behind performance gain in 12 with HashAggregate |
| Previous Message | Justin Pryzby | 2020-01-13 16:42:20 | Re: Seeking reason behind performance gain in 12 with HashAggregate |