From 0fdadfb0192935e0f8bec7fa5ec9dbb470d6d587 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 15 Sep 2018 17:24:35 -0400 Subject: In v11, disable JIT by default (it's still enabled by default in HEAD). Per discussion, JIT isn't quite mature enough to ship enabled-by-default. I failed to resist the temptation to do a bunch of copy-editing on the related documentation. Also, clean up some inconsistencies in which section of config.sgml the JIT GUCs are documented in vs. what guc.c and postgresql.config.sample had. Discussion: https://postgr.es/m/20180914222657.mw25esrzbcnu6qlu@alap3.anarazel.de --- src/backend/utils/misc/postgresql.conf.sample | 15 ++++++++------- 1 file changed, 8 insertions(+), 7 deletions(-) (limited to 'src/backend/utils/misc/postgresql.conf.sample') diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 9e39baf4668..163e3879b2e 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -321,11 +321,12 @@ #parallel_setup_cost = 1000.0 # same scale as above #jit_above_cost = 100000 # perform JIT compilation if available - # and query more expensive, -1 disables -#jit_optimize_above_cost = 500000 # optimize JITed functions if query is - # more expensive, -1 disables -#jit_inline_above_cost = 500000 # attempt to inline operators and - # functions if query is more expensive, + # and query more expensive than this; + # -1 disables +#jit_inline_above_cost = 500000 # inline small functions if query is + # more expensive than this; -1 disables +#jit_optimize_above_cost = 500000 # use expensive JIT optimizations if + # query is more expensive than this; # -1 disables #min_parallel_table_scan_size = 8MB @@ -351,6 +352,7 @@ #join_collapse_limit = 8 # 1 disables collapsing of explicit # JOIN clauses #force_parallel_mode = off +#jit = off # allow JIT compilation #------------------------------------------------------------------------------ @@ -615,13 +617,12 @@ #shared_preload_libraries = '' # (change requires restart) #local_preload_libraries = '' #session_preload_libraries = '' +#jit_provider = 'llvmjit' # JIT library to use # - Other Defaults - #dynamic_library_path = '$libdir' -#jit = on # allow JIT compilation -#jit_provider = 'llvmjit' # JIT implementation to use #------------------------------------------------------------------------------ # LOCK MANAGEMENT -- cgit v1.2.3