Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal

Поиск
Список
Период
Сортировка
От Mladen Gogala
Тема Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Дата
Msg-id 780e8797-b5a8-f02f-fbea-e01b625a34a7@gmail.com
обсуждение исходный текст
Ответ на Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On 3/4/22 17:03, Tom Lane wrote:
Mmm ... it might have just been that the planner chose not to use
JIT when it thought there were fewer rows involved.  Did you check
with EXPLAIN that these cut-down cases still used JIT?

This is interesting and informative answer. How do I check whether JIT is used in the explain plan? Can you give me an example?

TIA

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Interesting fail when migrating Pg from Ubuntu Bionic to Focal