Re: Query performance in 9.6.24 vs 14.10

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Query performance in 9.6.24 vs 14.10
Дата
Msg-id CANzqJaBbOpSvnWzFrhEppKzbFbN44rgsukHpKbKaMGwUrN_r3g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Query performance in 9.6.24 vs 14.10  (Bob Jolliffe <bobjolliffe@gmail.com>)
Ответы Re: Query performance in 9.6.24 vs 14.10
Список pgsql-general
Yes, jit=on.

I'll test them with jit=off, to see the difference.  (The application is 3rd party, so will change it at the system level.)

On Mon, Jan 29, 2024 at 7:09 AM Bob Jolliffe <bobjolliffe@gmail.com> wrote:
Out of curiosity, is the pg14 running with the default jit=on setting?  

This is obviously entirely due to the nature of the particular queries themselves, but we found that for our workloads that pg versions greater than 11 were exacting a huge cost due to the jit compiler.  Once we explicitly turned jit=off we started to see improvements. 

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

Предыдущее
От: Bob Jolliffe
Дата:
Сообщение: Re: Query performance in 9.6.24 vs 14.10
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Scriptable way to validate a pg_dump restore ?