Re: bad JIT decision

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: bad JIT decision
Дата
Msg-id CAApHDvoFsWpkwt+pKuuswChC+6EKQO+FfwicTQpSfTXAHDfoZw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: bad JIT decision  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: bad JIT decision  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-general
On Sat, 25 Jul 2020 at 10:37, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> David Rowley <dgrowleyml@gmail.com> writes:
> > However, for now, you might just want to try raising various jit
> > thresholds so that it only is enabled for more expensive plans.
>
> Yeah.  I'm fairly convinced that the v12 defaults are far too low,
> because we are constantly seeing complaints of this sort.

I think plan cost overestimation is a common cause of unwanted jit too.

It would be good to see the EXPLAIN ANALYZE so we knew if that was the
case here.

David



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: bad JIT decision
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: bad JIT decision