Turn jit off for slow subquery in Postgres 12

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

Responses

Browse pgsql-general by date

  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