PostgreSQL pg_jit_available() Function

The PostgreSQL pg_jit_available() function checks if the JIT compiler extension is available. This function returns true only if the JIT compiler extension is available and the jit parameter is configured as on.

pg_jit_available() Syntax

Here is the syntax of the PostgreSQL pg_jit_available() function:

pg_jit_available() -> boolean

Parameters

The PostgreSQL pg_jit_available() function does not require any parameters.

Return value

The PostgreSQL pg_jit_available() function checks if the JIT compiler extension is available. This function returns true only if the JIT compiler extension is available and the jit parameter is configured as on.

pg_jit_available() Examples

The following statements illustrate the pg_jit_available() basic usage of PostgreSQL functions:

SELECT pg_jit_available();

 pg_jit_available
------------------
 f

The function returns true only if the JIT compiler extension is available and the jit parameter is configured as on. If the jit parameter is configured off, the function always returns false whether or not JIT compiler extensions are available .

To configure the jit parameter as off, use the following statement:

SET jit TO off;

To configure the jit parameter as on, use the following statement:

SET jit TO on;

To view the current jit configuration , use the following statement:

SHOW jit;