Re: Default JIT setting in V12 - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Default JIT setting in V12
Date
Msg-id CAMkU=1x-hjo3cszwRG9PV=AvQzcmJ-+mQGqQVTbjoVmtEV4azg@mail.gmail.com
Whole thread Raw
In response to Re: Default JIT setting in V12  (Andres Freund <andres@anarazel.de>)
Responses Re: Default JIT setting in V12
List pgsql-hackers
On Wed, Sep 4, 2019 at 11:24 AM Andres Freund <andres@anarazel.de> wrote:
Hi,

On 2019-09-04 07:51:16 -0700, Andres Freund wrote:
 
Or better, something slightly more complete, like the attached (which
affects both code-gen time optimizations (which are more like peephole
ones), and both function/global ones that are cheap).

Yes, that does completely solve the issue I raised.  It makes JIT either better or at least harmless, even when falling into the gap between  jit_above_cost and jit_optimize_above_cost.

What TPC-H implementation do you use/recommend?  This one https://wiki.postgresql.org/wiki/DBT-3?

Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Kuntal Ghosh
Date:
Subject: Re: POC: Cleaning up orphaned files using undo logs
Next
From: Tom Lane
Date:
Subject: Re: Define jsonpath functions as stable