Re: bad JIT decision - Mailing list pgsql-general

From David Rowley
Subject Re: bad JIT decision
Date
Msg-id CAApHDvoFsWpkwt+pKuuswChC+6EKQO+FfwicTQpSfTXAHDfoZw@mail.gmail.com
Whole thread Raw
In response to Re: bad JIT decision  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: bad JIT decision
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: bad JIT decision
Next
From: Scott Ribe
Date:
Subject: Re: bad JIT decision