Re: is JIT available - Mailing list pgsql-general

From Pavel Stehule
Subject Re: is JIT available
Date
Msg-id CAFj8pRBaavFMFTEM=iio8pmsRd4Z-kwc-24cj6hH19L-nnXk+w@mail.gmail.com
Whole thread Raw
In response to Re: is JIT available  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-general


so 25. 7. 2020 v 14:33 odesílatel Scott Ribe <scott_ribe@elevated-dev.com> napsal:
> On Jul 25, 2020, at 6:21 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>
> It shows if Postgres was compiled with JIT support.
>
> When you run EXPLAIN ANALYZE SELECT ... then you can see info about JIT overhead. If you don't see notices about JIT in EXPLAIN, then JIT was not used.

The presence of "jit = on" in the config file does not indicate whether the running PG was actually compiled with JIT. And I'm not sure whether beyond that, compiling with JIT requires presence of anything outside the PG install.

 select * from pg_config where name = 'CONFIGURE' and setting like '%with-llvm';

if you see one row, then your postgres should be configured and compiled with JIT support

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: is JIT available
Next
From: Nils Bergmann
Date:
Subject: Format generation_expression