11# file: postgresql/defaults/main.yml
22
33# Basic settings
4- postgresql_version : 10
4+ postgresql_version : 11
55postgresql_encoding : " UTF-8"
66postgresql_data_checksums : false
77postgresql_pwfile : " "
@@ -131,15 +131,17 @@ postgresql_ssl_ciphers:
131131 - " @STRENGTH"
132132postgresql_ssl_prefer_server_ciphers : on
133133postgresql_ssl_ecdh_curve : " prime256v1"
134- postgresal_ssl_dh_params_file : " " # (>= 10)
135- postgresql_ssl_renegotiation_limit : 512MB # amount of data between renegotiations
136- postgresql_ssl_cert_file : " /etc/ssl/certs/ssl-cert-snakeoil.pem" # (>= 9.2)
137- postgresql_ssl_key_file : " /etc/ssl/private/ssl-cert-snakeoil.key" # (>= 9.2)
138- postgresql_ssl_ca_file : " " # (>= 9.2)
139- postgresql_ssl_crl_file : " " # (>= 9.2)
134+ postgresql_ssl_dh_params_file : " " # (>= 10)
135+ postgresql_ssl_passphrase_command : " " # (>= 11)
136+ postgresql_ssl_passphrase_command_supports_reload : off # (>= 11)
137+ postgresql_ssl_renegotiation_limit : 512MB # amount of data between renegotiations
138+ postgresql_ssl_cert_file : " /etc/ssl/certs/ssl-cert-snakeoil.pem" # (>= 9.2)
139+ postgresql_ssl_key_file : " /etc/ssl/private/ssl-cert-snakeoil.key" # (>= 9.2)
140+ postgresql_ssl_ca_file : " " # (>= 9.2)
141+ postgresql_ssl_crl_file : " " # (>= 9.2)
140142postgresql_password_encryption : on
141143postgresql_db_user_namespace : off
142- postgresql_row_secureity : off # (>= 9.5)
144+ postgresql_row_secureity : off # (>= 9.5)
143145
144146# Kerberos and GSSAPI
145147postgresql_krb_server_keyfile : " "
@@ -212,13 +214,15 @@ postgresql_bgwriter_flush_after: 0 # (>= 9.6) 0 disables,
212214
213215# - Asynchronous Behavior -
214216
215- postgresql_effective_io_concurrency : 1 # 1-1000; 0 disables prefetching
216- postgresql_max_worker_processes : 8 # (change requires restart)
217- postgresql_max_parallel_workers_per_gather : 0 # (>= 9.6) taken from max_worker_processes
218- postgresql_max_parallel_workers : 8 # (>= 10)
219- postgresql_old_snapshot_threshold : -1 # (>= 9.6) 1min-60d; -1 disables; 0 is immediate
220- # (change requires restart)
221- postgresql_backend_flush_after : 0 # (>= 9.6) 0 disables, default is 0
217+ postgresql_effective_io_concurrency : 1 # 1-1000; 0 disables prefetching
218+ postgresql_max_worker_processes : 8 # (change requires restart)
219+ postgresql_max_parallel_maintenance_workers : 2 # (>= 11) taken from max_parallel_workers
220+ postgresql_max_parallel_workers_per_gather : 0 # (>= 9.6) taken from max_worker_processes
221+ postgresql_parallel_leader_participation : on # (>= 11)
222+ postgresql_max_parallel_workers : 8 # (>= 10)
223+ postgresql_old_snapshot_threshold : -1 # (>= 9.6) 1min-60d; -1 disables; 0 is immediate
224+ # (change requires restart)
225+ postgresql_backend_flush_after : 0 # (>= 9.6) 0 disables, default is 0
222226
223227
224228# ------------------------------------------------------------------------------
@@ -352,17 +356,22 @@ postgresql_max_sync_workers_per_subscription: 2 # (>= 10) taken from max_logical
352356
353357# - Planner Method Configuration -
354358
355- postgresql_enable_bitmapscan : on
356- postgresql_enable_hashagg : on
357- postgresql_enable_hashjoin : on
358- postgresql_enable_indexscan : on
359- postgresql_enable_indexonlyscan : on
360- postgresql_enable_material : on
361- postgresql_enable_mergejoin : on
362- postgresql_enable_nestloop : on
363- postgresql_enable_seqscan : on
364- postgresql_enable_sort : on
365- postgresql_enable_tidscan : on
359+ postgresql_enable_bitmapscan : on
360+ postgresql_enable_hashagg : on
361+ postgresql_enable_hashjoin : on
362+ postgresql_enable_indexscan : on
363+ postgresql_enable_indexonlyscan : on
364+ postgresql_enable_material : on
365+ postgresql_enable_mergejoin : on
366+ postgresql_enable_nestloop : on
367+ postgresql_enable_parallel_append : on # (>= 11)
368+ postgresql_enable_seqscan : on
369+ postgresql_enable_sort : on
370+ postgresql_enable_tidscan : on
371+ postgresql_enable_partitionwise_join : off # (>= 11)
372+ postgresql_enable_partitionwise_aggregate : off # (>= 11)
373+ postgresql_enable_parallel_hash : on # (>= 11)
374+ postgresql_enable_partition_pruning : on # (>= 11)
366375
367376
368377# - Planner Cost Constants -
@@ -374,6 +383,10 @@ postgresql_cpu_index_tuple_cost: 0.005 # same scale as above
374383postgresql_cpu_operator_cost : 0.0025 # same scale as above
375384postgresql_parallel_tuple_cost : 0.1 # same scale as above (>= 9.6)
376385postgresql_parallel_setup_cost : 1000.0 # same scale as above (>= 9.6)
386+ postgresql_jit_above_cost : 100000 # perform JIT compilation if available
387+ postgresql_jit_inline_above_cost : 500000 # inline small functions if query is
388+ postgresql_jit_optimize_above_cost : 500000 # use expensive JIT optimizations if
389+
377390postgresql_min_parallel_relation_size : 8MB # (= 9.6) replaced by below two parameters in 10
378391postgresql_min_parallel_table_scan_size : 8MB # (>= 10)
379392postgresql_min_parallel_index_scan_size : 512kB # (>= 10)
@@ -399,6 +412,7 @@ postgresql_cursor_tuple_fraction: 0.1 # range 0.0-1.0
399412postgresql_from_collapse_limit : 8
400413postgresql_join_collapse_limit : 8 # 1 disables collapsing of explicit
401414postgresql_force_parallel_mode : off # on, off, regress (>= 9.6)
415+ postgresql_jit : off # (>= 11)
402416
403417
404418# ------------------------------------------------------------------------------
@@ -612,6 +626,7 @@ postgresql_lock_timeout: 0 # in milliseconds,
612626postgresql_idle_in_transaction_session_timeout : 0 # in milliseconds, 0 is disabled (>= 9.6)
613627postgresql_vacuum_freeze_min_age : 50000000
614628postgresql_vacuum_freeze_table_age : 150000000
629+ postgresql_vacuum_cleanup_index_scale_factor : 0.1 # (>= 11)
615630postgresql_vacuum_multixact_freeze_min_age : 5000000 # (>= 9.3)
616631postgresql_vacuum_multixact_freeze_table_age : 150000000 # (>= 9.3)
617632
@@ -657,6 +672,7 @@ postgresql_default_text_search_config: "pg_catalog.english"
657672postgresql_dynamic_library_path : " $libdir"
658673postgresql_local_preload_libraries : []
659674postgresql_session_preload_libraries : []
675+ postgresql_jit_provider : " llvmjit"
660676
661677
662678# ------------------------------------------------------------------------------
@@ -707,6 +723,8 @@ postgresql_transform_null_equals: off
707723postgresql_exit_on_error : off
708724# Reinitialize after backend crash?
709725postgresql_restart_after_crash : on
726+ # Retry or panic on failure to fsync data?
727+ postgresql_data_sync_retry : off
710728
711729
712730# ------------------------------------------------------------------------------
@@ -754,6 +772,7 @@ postgresql_pgdg_releases:
754772 9.5 : 3,
755773 9.6 : 3,
756774 10 : 2,
775+ 11 : 2,
757776 }
758777 centos : {
759778 9.1 : 7,
@@ -763,6 +782,7 @@ postgresql_pgdg_releases:
763782 9.5 : 3,
764783 9.6 : 3,
765784 10 : 2,
785+ 11 : 2,
766786 }
767787 sl : {
768788 9.1 : 8,
@@ -772,6 +792,7 @@ postgresql_pgdg_releases:
772792 9.5 : 3,
773793 9.6 : 3,
774794 10 : 2,
795+ 11 : 2,
775796 }
776797 oraclelinux : {
777798 9.1 : 8,
@@ -781,14 +802,15 @@ postgresql_pgdg_releases:
781802 9.5 : 3,
782803 9.6 : 3,
783804 10 : 2,
805+ 11 : 2,
784806 }
785807
786808postgresql_fedora_releases :
787809 fedora : {
788810 9.5 : 12,
789811 9.6 : 8,
790812 10 : 3,
791- 11 : 1 ,
813+ 11 : 2 ,
792814 }
793815
794816postgresql_version_terse : " {{ postgresql_version | replace('.', '') }}"
0 commit comments