Re: Performance degradation if query returns no rows and columnexpression is used after upgrading to 12

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Performance degradation if query returns no rows and columnexpression is used after upgrading to 12
Дата
Msg-id CAFj8pRA9bk4_cYUj9=UWG-XyKfeRCawFD0j-BBRp0+4Z8u2Bjw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12  ("Andrus" <kobruleht2@hot.ee>)
Ответы Re: Performance degradation if query returns no rows and column expression is used after upgrading to 12
Список pgsql-general
Дерево обсуждения


út 7. 4. 2020 v 19:09 odesílatel Andrus <kobruleht2@hot.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Estimated resources for a 500 connections instance (VM)
Следующее
От: David Gauthier
Дата:
Сообщение: Re: Estimated resources for a 500 connections instance (VM)