Re: information_schema performance in Postgres 12

Поиск
Список
Период
Сортировка
От Eric Gillum
Тема Re: information_schema performance in Postgres 12
Дата
Msg-id CAMmjdmsQLj6VjQ=Dt49HGxV51iOPCAD7XP39m3VGOpXF+y9BwA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: information_schema performance in Postgres 12  (Michael Lewis <mlewis@entrata.com>)
Ответы Re: information_schema performance in Postgres 12
Список pgsql-general
Дерево обсуждения
Does not seem to improve if I turn off JIT. 

# show jit;
 on
# explain analyze SELECT tc.table_name, ...
 Planning Time: 8.806 ms
 Execution Time: 511.249 ms
# set jit=false;
# show jit;
 off
# explain analyze SELECT tc.table_name, ...
 Planning Time: 8.980 ms
 Execution Time: 506.016 ms



On Wed, Feb 26, 2020 at 8:41 AM Michael Lewis <mlewis@entrata.com> wrote:
Have you tried with JIT turned off in PG12? The long running node is ProjectSet type which is related to set returning functions. If that is getting evaluated differently in PG12, that may be issue.

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

Предыдущее
От: Klaus Darilion
Дата:
Сообщение: How to know if initial sync of logical subscription is finished
Следующее
От: Albrecht Dreß
Дата:
Сообщение: Re: Error“cache lookup failed for function”