From: | Andrus <kobruleht2(at)hot(dot)ee> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Turn jit off for slow subquery in Postgres 12 |
Date: | 2021-02-16 06:48:35 |
Message-ID: | c18b027c-4629-58a5-a499-64dc8a233e8f@hot.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
Last year I posted testcase [1] which shows that using jit makes execution
magnitude slower ( 2.5s vs 0.4 sec) in typical shopping cart application
product search in Postgres 12.
There are also other reports on this [2,3].
I tried to turn jit off for subquery using
select ... from
(
set jit to off;
select ... from cartdata, ... where ....
set jit to on
)
But this cause syntax error.
How to turn off jit for specific subquery in Postgres 12 ?
Subquery is generated by EF Core and splitting it to multiple statements
is not possible.
Postgres upgrade is not planned.
Andrus.
[1]
https://www.postgresql.org/message-id/A2E2572094D4434CAEB57C80085B22C7@dell2
[2]
https://www.postgresql.org/message-id/CAHOFxGo5xJt02RmwAWrtv2K0jcqqxG-cDiR8FQbvb0WxdKhcgw%40mail.gmail.com
[3]https://www.postgresql.org/message-id/629715.1595630222%40sss.pgh.pa.us
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2021-02-16 06:52:09 | Re: Turn jit off for slow subquery in Postgres 12 |
Previous Message | Abdul Qoyyuum | 2021-02-16 06:32:49 | Re: ALTER ROLE ... SET in current database only |