From: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
---|---|
To: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Query is over 2x slower with jit=on |
Date: | 2018-08-23 07:14:56 |
Message-ID: | VisenaEmail.2.c105fe39c156917b.165659f1429@tc7-visena |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
På torsdag 23. august 2018 kl. 03:00:42, skrev Jonathan S. Katz <
jkatz(at)postgresql(dot)org <mailto:jkatz(at)postgresql(dot)org>>:
> On Aug 22, 2018, at 7:13 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
[snip]
> For the archives sake: This likely largely is the consequence of
> building with LLVM's expensive assertions enabled, as confirmed by
> Jonathan over IM.
I recompiled with the release version of LLVM. jit=on was still slower,
but the discrepancy was not as bad as the previously reported result:
jit = off
Planning Time: 0.938 ms
Execution Time: 935.599 ms
jit = on
Planning Time: 0.951 ms
JIT:
Functions: 184
Generation Time: 17.605 ms
Inlining: true
Inlining Time: 20.522 ms
Optimization: true
Optimization Time: 1001.034 ms
Emission Time: 665.319 ms
Execution Time: 2491.560 ms
However, it was still 2x+ slower, so still +1ing for open items.
I compiled with whatever switches LLVM that comes with Ubuntu 18.04 is built
with, and without debugging or assertions.
--
Andreas Joseph Krogh
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Kukushkin | 2018-08-23 08:01:08 | Re: BUG #15346: Replica fails to start after the crash |
Previous Message | Pavel Stehule | 2018-08-23 06:35:19 | Re: proposal: schema private functions |