út 7. 4. 2020 v 19:09 odesílatel Andrus <kobruleht2(at)hot(dot)ee> napsal:
> Hi!
> >on your query there is too slow JIT. Is strange how much. So the best way
> is disable JIT probably
> >set jit to off;
> >or same field in postgresql.conf
>
> Thank you.
>
> set jit to off
>
> makes select fast.
> I have encountered this issue only in this query in one database
>
> There is variation of this query running with diferent data in different
> database in same Debian 10 server. It works fast.
> Should I disable jit only for this query or in postgresql.conf permanently?
>
you can do it in session
SET jit to off;
SELECT ..
SET jit to DEFAULT;
It is really strange why it is too slow. Can you prepare test case? Looks
like bug (maybe not Postgres's bug)
Pavel
> Andrus.
>