Re: Defaulting to jit=on/off for v11

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Defaulting to jit=on/off for v11
Date: 2018-09-14 22:32:03
Message-ID: 3949.1536964323@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund <andres(at)anarazel(dot)de> writes:
> I can see basically three sensible routes to go for v11 (before we
> improve further):

> 1) Leave it enabled, as currently.

> 2) Disable it by default in v11, leave it enabled in master.

> 3) Increase the costs substantially, so it triggers in far fewer
> cases. Those would be too high for cases that want to benefit fully,
> but would reduce the risk - although it also probably makes it
> harder to easily hit problematic cases.

I'd go with #2, personally. It does seem that the costing needs work,
but it's not clear to me that we know what to change, so it's kinda
late to propose #3 for v11.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2018-09-14 22:37:40 Re: move PartitionDispatchData definition to execPartition.c
Previous Message Andres Freund 2018-09-14 22:26:57 Defaulting to jit=on/off for v11