diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index a782f10998..129e44702a 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -642,7 +642,7 @@ include_dir 'conf.d' - listen_addresses (string) + listen_addresses (string) - default is localhost listen_addresses configuration parameter @@ -678,7 +678,7 @@ include_dir 'conf.d' - port (integer) + port (integer) - default is 5432 port configuration parameter @@ -693,7 +693,7 @@ include_dir 'conf.d' - max_connections (integer) + max_connections (integer) - default is 100 max_connections configuration parameter @@ -722,7 +722,7 @@ include_dir 'conf.d' - reserved_connections (integer) + reserved_connections (integer) - default is 0 reserved_connections configuration parameter @@ -755,7 +755,7 @@ include_dir 'conf.d' superuser_reserved_connections - (integer) + (integer) - default is 3 superuser_reserved_connections configuration parameter @@ -785,7 +785,7 @@ include_dir 'conf.d' - unix_socket_directories (string) + unix_socket_directories (string) - default is /tmp, on Windows is an empty string unix_socket_directories configuration parameter @@ -836,7 +836,7 @@ include_dir 'conf.d' - unix_socket_group (string) + unix_socket_group (string) - default is an empty string unix_socket_group configuration parameter @@ -862,7 +862,7 @@ include_dir 'conf.d' - unix_socket_permissions (integer) + unix_socket_permissions (integer) - default is 0777 unix_socket_permissions configuration parameter @@ -912,7 +912,7 @@ include_dir 'conf.d' - bonjour (boolean) + bonjour (boolean) - default is off bonjour configuration parameter @@ -927,7 +927,7 @@ include_dir 'conf.d' - bonjour_name (string) + bonjour_name (string) - default is an empty string bonjour_name configuration parameter @@ -952,7 +952,7 @@ include_dir 'conf.d' - tcp_keepalives_idle (integer) + tcp_keepalives_idle (integer) - default is 0 tcp_keepalives_idle configuration parameter @@ -975,7 +975,7 @@ include_dir 'conf.d' - tcp_keepalives_interval (integer) + tcp_keepalives_interval (integer) - default is 0 tcp_keepalives_interval configuration parameter @@ -998,7 +998,7 @@ include_dir 'conf.d' - tcp_keepalives_count (integer) + tcp_keepalives_count (integer) - default is 0 tcp_keepalives_count configuration parameter @@ -1018,7 +1018,7 @@ include_dir 'conf.d' - tcp_user_timeout (integer) + tcp_user_timeout (integer) - default is 0 tcp_user_timeout configuration parameter @@ -1038,7 +1038,7 @@ include_dir 'conf.d' - client_connection_check_interval (integer) + client_connection_check_interval (integer) - default is 0 client_connection_check_interval configuration parameter @@ -1082,7 +1082,7 @@ include_dir 'conf.d' - authentication_timeout (integer) + authentication_timeout (integer) - default is 1m timeoutclient authentication client authenticationtimeout during @@ -1105,7 +1105,7 @@ include_dir 'conf.d' - password_encryption (enum) + password_encryption (enum) - default is scram-sha-256 password_encryption configuration parameter @@ -1136,7 +1136,7 @@ include_dir 'conf.d' - scram_iterations (integer) + scram_iterations (integer) - default is 4096 scram_iterations configuration parameter @@ -1156,7 +1156,7 @@ include_dir 'conf.d' - krb_server_keyfile (string) + krb_server_keyfile (string) - default is FILE:/usr/local/pgsql/etc/krb5.keytab krb_server_keyfile configuration parameter @@ -1178,7 +1178,7 @@ include_dir 'conf.d' - krb_caseins_users (boolean) + krb_caseins_users (boolean) - default is off krb_caseins_users configuration parameter @@ -1194,7 +1194,7 @@ include_dir 'conf.d' - gss_accept_delegation (boolean) + gss_accept_delegation (boolean) - default is off gss_accept_delegation configuration parameter @@ -1227,7 +1227,7 @@ include_dir 'conf.d' - ssl (boolean) + ssl (boolean) - default is off ssl configuration parameter @@ -1243,7 +1243,7 @@ include_dir 'conf.d' - ssl_ca_file (string) + ssl_ca_file (string) - default is an empty string ssl_ca_file configuration parameter @@ -1262,7 +1262,7 @@ include_dir 'conf.d' - ssl_cert_file (string) + ssl_cert_file (string) - default is server.crt ssl_cert_file configuration parameter @@ -1279,7 +1279,7 @@ include_dir 'conf.d' - ssl_crl_file (string) + ssl_crl_file (string) - default is an empty string ssl_crl_file configuration parameter @@ -1298,7 +1298,7 @@ include_dir 'conf.d' - ssl_crl_dir (string) + ssl_crl_dir (string) - default is an empty string ssl_crl_dir configuration parameter @@ -1332,7 +1332,7 @@ include_dir 'conf.d' - ssl_key_file (string) + ssl_key_file (string) - default is server.key ssl_key_file configuration parameter @@ -1349,7 +1349,7 @@ include_dir 'conf.d' - ssl_tls13_ciphers (string) + ssl_tls13_ciphers (string) - default is HIGH:MEDIUM:+3DES:!aNULL ssl_tls13_ciphers configuration parameter @@ -1371,7 +1371,7 @@ include_dir 'conf.d' - ssl_ciphers (string) + ssl_ciphers (string) - default is HIGH:MEDIUM:+3DES:!aNULL ssl_ciphers configuration parameter @@ -1456,7 +1456,7 @@ include_dir 'conf.d' - ssl_prefer_server_ciphers (boolean) + ssl_prefer_server_ciphers (boolean) - default is on ssl_prefer_server_ciphers configuration parameter @@ -1481,7 +1481,7 @@ include_dir 'conf.d' - ssl_groups (string) + ssl_groups (string) - default is prime256v1 ssl_groups configuration parameter @@ -1518,7 +1518,7 @@ include_dir 'conf.d' - ssl_min_protocol_version (enum) + ssl_min_protocol_version (enum) - default is TLSv1.2 ssl_min_protocol_version configuration parameter @@ -1547,7 +1547,7 @@ include_dir 'conf.d' - ssl_max_protocol_version (enum) + ssl_max_protocol_version (enum) - default is to allow any version ssl_max_protocol_version configuration parameter @@ -1570,7 +1570,7 @@ include_dir 'conf.d' - ssl_dh_params_file (string) + ssl_dh_params_file (string) - default is an empty string ssl_dh_params_file configuration parameter @@ -1594,7 +1594,7 @@ include_dir 'conf.d' - ssl_passphrase_command (string) + ssl_passphrase_command (string) - default is an empty string ssl_passphrase_command configuration parameter @@ -1628,7 +1628,7 @@ include_dir 'conf.d' - ssl_passphrase_command_supports_reload (boolean) + ssl_passphrase_command_supports_reload (boolean) - default is off ssl_passphrase_command_supports_reload configuration parameter @@ -1664,7 +1664,7 @@ include_dir 'conf.d' - shared_buffers (integer) + shared_buffers (integer) - default is 128MB shared_buffers configuration parameter @@ -1709,7 +1709,7 @@ include_dir 'conf.d' - huge_pages (enum) + huge_pages (enum) - default is try huge_pages configuration parameter @@ -1772,7 +1772,7 @@ include_dir 'conf.d' - huge_page_size (integer) + huge_page_size (integer) - default is 0 huge_page_size configuration parameter @@ -1799,7 +1799,7 @@ include_dir 'conf.d' - temp_buffers (integer) + temp_buffers (integer) - default is 8MB temp_buffers configuration parameter @@ -1833,7 +1833,7 @@ include_dir 'conf.d' - max_prepared_transactions (integer) + max_prepared_transactions (integer) - default is 0 max_prepared_transactions configuration parameter @@ -1866,7 +1866,7 @@ include_dir 'conf.d' - work_mem (integer) + work_mem (integer) - default is 4MB work_mem configuration parameter @@ -1905,7 +1905,7 @@ include_dir 'conf.d' - hash_mem_multiplier (floating point) + hash_mem_multiplier (floating point) - default is 2.0 hash_mem_multiplier configuration parameter @@ -1935,7 +1935,7 @@ include_dir 'conf.d' - maintenance_work_mem (integer) + maintenance_work_mem (integer) - default is 64MB maintenance_work_mem configuration parameter @@ -1965,7 +1965,7 @@ include_dir 'conf.d' - autovacuum_work_mem (integer) + autovacuum_work_mem (integer) - default is -1 autovacuum_work_mem configuration parameter @@ -1988,7 +1988,7 @@ include_dir 'conf.d' - vacuum_buffer_usage_limit (integer) + vacuum_buffer_usage_limit (integer) - default is 2MB vacuum_buffer_usage_limit configuration parameter @@ -2017,7 +2017,7 @@ include_dir 'conf.d' - logical_decoding_work_mem (integer) + logical_decoding_work_mem (integer) - default is 64MB logical_decoding_work_mem configuration parameter @@ -2038,7 +2038,7 @@ include_dir 'conf.d' - commit_timestamp_buffers (integer) + commit_timestamp_buffers (integer) - default is 0 commit_timestamp_buffers configuration parameter @@ -2059,7 +2059,7 @@ include_dir 'conf.d' - multixact_member_buffers (integer) + multixact_member_buffers (integer) - default is 32 multixact_member_buffers configuration parameter @@ -2078,7 +2078,7 @@ include_dir 'conf.d' - multixact_offset_buffers (integer) + multixact_offset_buffers (integer) - default is 16 multixact_offset_buffers configuration parameter @@ -2097,7 +2097,7 @@ include_dir 'conf.d' - notify_buffers (integer) + notify_buffers (integer) - default is 16 notify_buffers configuration parameter @@ -2116,7 +2116,7 @@ include_dir 'conf.d' - serializable_buffers (integer) + serializable_buffers (integer) - default is 32 serializable_buffers configuration parameter @@ -2135,7 +2135,7 @@ include_dir 'conf.d' - subtransaction_buffers (integer) + subtransaction_buffers (integer) - default is 0 subtransaction_buffers configuration parameter @@ -2156,7 +2156,7 @@ include_dir 'conf.d' - transaction_buffers (integer) + transaction_buffers (integer) - default is 0 transaction_buffers configuration parameter @@ -2177,7 +2177,7 @@ include_dir 'conf.d' - max_stack_depth (integer) + max_stack_depth (integer) - default is 2MB max_stack_depth configuration parameter @@ -2211,7 +2211,7 @@ include_dir 'conf.d' - shared_memory_type (enum) + shared_memory_type (enum) - default is first supported option for that platform shared_memory_type configuration parameter @@ -2236,7 +2236,7 @@ include_dir 'conf.d' - dynamic_shared_memory_type (enum) + dynamic_shared_memory_type (enum) - default is first supported option for that platform dynamic_shared_memory_type configuration parameter @@ -2263,7 +2263,7 @@ include_dir 'conf.d' - min_dynamic_shared_memory (integer) + min_dynamic_shared_memory (integer) - default is 0 min_dynamic_shared_memory configuration parameter @@ -2295,7 +2295,7 @@ include_dir 'conf.d' - temp_file_limit (integer) + temp_file_limit (integer) - default is -1 temp_file_limit configuration parameter @@ -2322,7 +2322,7 @@ include_dir 'conf.d' - max_notify_queue_pages (integer) + max_notify_queue_pages (integer) - default is 1048576 max_notify_queue_pages configuration parameter @@ -2345,7 +2345,7 @@ include_dir 'conf.d' - max_files_per_process (integer) + max_files_per_process (integer) - default is 1000 files max_files_per_process configuration parameter @@ -2390,7 +2390,7 @@ include_dir 'conf.d' - bgwriter_delay (integer) + bgwriter_delay (integer) - default is 200ms bgwriter_delay configuration parameter @@ -2418,7 +2418,7 @@ include_dir 'conf.d' - bgwriter_lru_maxpages (integer) + bgwriter_lru_maxpages (integer) - default is 100 buffers bgwriter_lru_maxpages configuration parameter @@ -2437,7 +2437,7 @@ include_dir 'conf.d' - bgwriter_lru_multiplier (floating point) + bgwriter_lru_multiplier (floating point) - default is 2.0 bgwriter_lru_multiplier configuration parameter @@ -2465,7 +2465,7 @@ include_dir 'conf.d' - bgwriter_flush_after (integer) + bgwriter_flush_after (integer) - default is 512kB on Linux, 0 elsewhere bgwriter_flush_after configuration parameter @@ -2511,7 +2511,7 @@ include_dir 'conf.d' - backend_flush_after (integer) + backend_flush_after (integer) - default is 0 backend_flush_after configuration parameter @@ -2541,7 +2541,7 @@ include_dir 'conf.d' - effective_io_concurrency (integer) + effective_io_concurrency (integer) - default is 1 on supported systems, otherwise 0 effective_io_concurrency configuration parameter @@ -2586,7 +2586,7 @@ include_dir 'conf.d' - maintenance_io_concurrency (integer) + maintenance_io_concurrency (integer) - default is 10 on supported systems, otherwise 0 maintenance_io_concurrency configuration parameter @@ -2606,7 +2606,7 @@ include_dir 'conf.d' - io_combine_limit (integer) + io_combine_limit (integer) - default is 128kb io_combine_limit configuration parameter @@ -2620,7 +2620,7 @@ include_dir 'conf.d' - max_worker_processes (integer) + max_worker_processes (integer) - default is 8 max_worker_processes configuration parameter @@ -2648,7 +2648,7 @@ include_dir 'conf.d' - max_parallel_workers_per_gather (integer) + max_parallel_workers_per_gather (integer) - default is 2 max_parallel_workers_per_gather configuration parameter @@ -2690,7 +2690,7 @@ include_dir 'conf.d' - max_parallel_maintenance_workers (integer) + max_parallel_maintenance_workers (integer) - default is 2 max_parallel_maintenance_workers configuration parameter @@ -2728,7 +2728,7 @@ include_dir 'conf.d' - max_parallel_workers (integer) + max_parallel_workers (integer) - default is 8 max_parallel_workers configuration parameter @@ -2750,7 +2750,7 @@ include_dir 'conf.d' - parallel_leader_participation (boolean) + parallel_leader_participation (boolean) - default is on parallel_leader_participation configuration parameter @@ -2787,7 +2787,7 @@ include_dir 'conf.d' - wal_level (enum) + wal_level (enum) - default is replica wal_level configuration parameter @@ -2910,7 +2910,7 @@ include_dir 'conf.d' - synchronous_commit (enum) + synchronous_commit (enum) - default is on synchronous_commit configuration parameter @@ -3065,7 +3065,7 @@ include_dir 'conf.d' - wal_sync_method (enum) + wal_sync_method (enum) - default is the first method supported by the platform wal_sync_method configuration parameter @@ -3120,7 +3120,7 @@ include_dir 'conf.d' - full_page_writes (boolean) + full_page_writes (boolean) - default is on full_page_writes configuration parameter @@ -3167,7 +3167,7 @@ include_dir 'conf.d' - wal_log_hints (boolean) + wal_log_hints (boolean) - default is off wal_log_hints configuration parameter @@ -3194,7 +3194,7 @@ include_dir 'conf.d' - wal_compression (enum) + wal_compression (enum) - default is off wal_compression configuration parameter @@ -3227,7 +3227,7 @@ include_dir 'conf.d' - wal_init_zero (boolean) + wal_init_zero (boolean) - default is on wal_init_zero configuration parameter @@ -3246,7 +3246,7 @@ include_dir 'conf.d' - wal_recycle (boolean) + wal_recycle (boolean) - default is on wal_recycle configuration parameter @@ -3262,7 +3262,7 @@ include_dir 'conf.d' - wal_buffers (integer) + wal_buffers (integer) - default is -1 wal_buffers configuration parameter @@ -3296,7 +3296,7 @@ include_dir 'conf.d' - wal_writer_delay (integer) + wal_writer_delay (integer) - default is 200ms wal_writer_delay configuration parameter @@ -3323,7 +3323,7 @@ include_dir 'conf.d' - wal_writer_flush_after (integer) + wal_writer_flush_after (integer) - default is 1MB wal_writer_flush_after configuration parameter @@ -3347,7 +3347,7 @@ include_dir 'conf.d' - wal_skip_threshold (integer) + wal_skip_threshold (integer) - default is 2MB wal_skip_threshold configuration parameter @@ -3368,7 +3368,7 @@ include_dir 'conf.d' - commit_delay (integer) + commit_delay (integer) - default is 0 commit_delay configuration parameter @@ -3406,7 +3406,7 @@ include_dir 'conf.d' - commit_siblings (integer) + commit_siblings (integer) - default is 5 transactions commit_siblings configuration parameter @@ -3429,7 +3429,7 @@ include_dir 'conf.d' - checkpoint_timeout (integer) + checkpoint_timeout (integer) - default is 5 minutes checkpoint_timeout configuration parameter @@ -3449,7 +3449,7 @@ include_dir 'conf.d' - checkpoint_completion_target (floating point) + checkpoint_completion_target (floating point) - default is 0.9 checkpoint_completion_target configuration parameter @@ -3471,7 +3471,7 @@ include_dir 'conf.d' - checkpoint_flush_after (integer) + checkpoint_flush_after (integer) - default is 256kb checkpoint_flush_after configuration parameter @@ -3503,7 +3503,7 @@ include_dir 'conf.d' - checkpoint_warning (integer) + checkpoint_warning (integer) - default is 30 seconds checkpoint_warning configuration parameter @@ -3526,7 +3526,7 @@ include_dir 'conf.d' - max_wal_size (integer) + max_wal_size (integer) - default is 1GB max_wal_size configuration parameter @@ -3549,7 +3549,7 @@ include_dir 'conf.d' - min_wal_size (integer) + min_wal_size (integer) - default is 80MB min_wal_size configuration parameter @@ -3610,7 +3610,7 @@ include_dir 'conf.d' - archive_command (string) + archive_command (string) - default is an empty string archive_command configuration parameter @@ -3650,7 +3650,7 @@ include_dir 'conf.d' - archive_library (string) + archive_library (string) - default is an empty string archive_library configuration parameter @@ -3730,7 +3730,7 @@ include_dir 'conf.d' - recovery_prefetch (enum) + recovery_prefetch (enum) - default is try recovery_prefetch configuration parameter @@ -3756,7 +3756,7 @@ include_dir 'conf.d' - wal_decode_buffer_size (integer) + wal_decode_buffer_size (integer) - default is 512kb wal_decode_buffer_size configuration parameter @@ -4072,7 +4072,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target_inclusive (boolean) + recovery_target_inclusive (boolean) - default is on recovery_target_inclusive configuration parameter @@ -4094,7 +4094,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target_timeline (string) + recovery_target_timeline (string) - default is latest recovery_target_timeline configuration parameter @@ -4129,7 +4129,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - recovery_target_action (enum) + recovery_target_action (enum) - default is pause recovery_target_action configuration parameter @@ -4198,7 +4198,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - summarize_wal (boolean) + summarize_wal (boolean) - default is off summarize_wal configuration parameter @@ -4222,7 +4222,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - wal_summary_keep_time (integer) + wal_summary_keep_time (integer) - default is 10 days wal_summary_keep_time configuration parameter @@ -4302,7 +4302,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - max_wal_senders (integer) + max_wal_senders (integer) - default is 10 max_wal_senders configuration parameter @@ -4332,7 +4332,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - max_replication_slots (integer) + max_replication_slots (integer) - default is 10 max_replication_slots configuration parameter in a sending server @@ -4361,7 +4361,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - wal_keep_size (integer) + wal_keep_size (integer) - default is 0 wal_keep_size configuration parameter @@ -4398,7 +4398,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - max_slot_wal_keep_size (integer) + max_slot_wal_keep_size (integer) - default is -1 max_slot_wal_keep_size configuration parameter @@ -4424,7 +4424,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - wal_sender_timeout (integer) + wal_sender_timeout (integer) - default is 60 seconds wal_sender_timeout configuration parameter @@ -4451,7 +4451,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows - track_commit_timestamp (boolean) + track_commit_timestamp (boolean) - default is off track_commit_timestamp configuration parameter @@ -4741,7 +4741,7 @@ ANY num_sync ( - hot_standby (boolean) + hot_standby (boolean) - default is on hot_standby configuration parameter @@ -4758,7 +4758,7 @@ ANY num_sync ( - max_standby_archive_delay (integer) + max_standby_archive_delay (integer) - default is 30 seconds max_standby_archive_delay configuration parameter @@ -4790,7 +4790,7 @@ ANY num_sync ( - max_standby_streaming_delay (integer) + max_standby_streaming_delay (integer) - default is 30 seconds max_standby_streaming_delay configuration parameter @@ -4823,7 +4823,7 @@ ANY num_sync ( - wal_receiver_create_temp_slot (boolean) + wal_receiver_create_temp_slot (boolean) - default is off wal_receiver_create_temp_slot configuration parameter @@ -4843,7 +4843,7 @@ ANY num_sync ( - wal_receiver_status_interval (integer) + wal_receiver_status_interval (integer) - default is 10 seconds wal_receiver_status_interval configuration parameter @@ -4875,7 +4875,7 @@ ANY num_sync ( - hot_standby_feedback (boolean) + hot_standby_feedback (boolean) - default is off hot_standby_feedback configuration parameter @@ -4901,7 +4901,7 @@ ANY num_sync ( - wal_receiver_timeout (integer) + wal_receiver_timeout (integer) - default is 60 seconds wal_receiver_timeout configuration parameter @@ -4923,7 +4923,7 @@ ANY num_sync ( - wal_retrieve_retry_interval (integer) + wal_retrieve_retry_interval (integer) - default is 5 seconds wal_retrieve_retry_interval configuration parameter @@ -4960,7 +4960,7 @@ ANY num_sync ( - recovery_min_apply_delay (integer) + recovery_min_apply_delay (integer) - default is 0 recovery_min_apply_delay configuration parameter @@ -5031,7 +5031,7 @@ ANY num_sync ( - sync_replication_slots (boolean) + sync_replication_slots (boolean) - default is off sync_replication_slots configuration parameter @@ -5093,7 +5093,7 @@ ANY num_sync ( - max_logical_replication_workers (integer) + max_logical_replication_workers (integer) - default is 4 max_logical_replication_workers configuration parameter @@ -5116,7 +5116,7 @@ ANY num_sync ( - max_sync_workers_per_subscription (integer) + max_sync_workers_per_subscription (integer) - default is 2 max_sync_workers_per_subscription configuration parameter @@ -5143,7 +5143,7 @@ ANY num_sync ( - max_parallel_apply_workers_per_subscription (integer) + max_parallel_apply_workers_per_subscription (integer) - default is 2 max_parallel_apply_workers_per_subscription configuration parameter @@ -5198,7 +5198,7 @@ ANY num_sync ( - enable_async_append (boolean) + enable_async_append (boolean) - default is on enable_async_append configuration parameter @@ -5212,7 +5212,7 @@ ANY num_sync ( - enable_bitmapscan (boolean) + enable_bitmapscan (boolean) - default is on bitmap scan @@ -5243,7 +5243,7 @@ ANY num_sync ( - enable_gathermerge (boolean) + enable_gathermerge (boolean) - default is on enable_gathermerge configuration parameter @@ -5257,7 +5257,7 @@ ANY num_sync ( - enable_group_by_reordering (boolean) + enable_group_by_reordering (boolean) - default is on enable_group_by_reordering configuration parameter @@ -5276,7 +5276,7 @@ ANY num_sync ( - enable_hashagg (boolean) + enable_hashagg (boolean) - default is on enable_hashagg configuration parameter @@ -5290,7 +5290,7 @@ ANY num_sync ( - enable_hashjoin (boolean) + enable_hashjoin (boolean) - default is on enable_hashjoin configuration parameter @@ -5304,7 +5304,7 @@ ANY num_sync ( - enable_incremental_sort (boolean) + enable_incremental_sort (boolean) - default is on enable_incremental_sort configuration parameter @@ -5318,7 +5318,7 @@ ANY num_sync ( - enable_indexscan (boolean) + enable_indexscan (boolean) - default is on index scan @@ -5336,7 +5336,7 @@ ANY num_sync ( - enable_indexonlyscan (boolean) + enable_indexonlyscan (boolean) - default is on enable_indexonlyscan configuration parameter @@ -5353,7 +5353,7 @@ ANY num_sync ( - enable_material (boolean) + enable_material (boolean) - default is on enable_material configuration parameter @@ -5370,7 +5370,7 @@ ANY num_sync ( - enable_memoize (boolean) + enable_memoize (boolean) - default is on enable_memoize configuration parameter @@ -5389,7 +5389,7 @@ ANY num_sync ( - enable_mergejoin (boolean) + enable_mergejoin (boolean) - default is on enable_mergejoin configuration parameter @@ -5403,7 +5403,7 @@ ANY num_sync ( - enable_nestloop (boolean) + enable_nestloop (boolean) - default is on enable_nestloop configuration parameter @@ -5420,7 +5420,7 @@ ANY num_sync ( - enable_parallel_append (boolean) + enable_parallel_append (boolean) - default is on enable_parallel_append configuration parameter @@ -5434,7 +5434,7 @@ ANY num_sync ( - enable_parallel_hash (boolean) + enable_parallel_hash (boolean) - default is on enable_parallel_hash configuration parameter @@ -5449,7 +5449,7 @@ ANY num_sync ( - enable_partition_pruning (boolean) + enable_partition_pruning (boolean) - default is on enable_partition_pruning configuration parameter @@ -5467,7 +5467,7 @@ ANY num_sync ( - enable_partitionwise_join (boolean) + enable_partitionwise_join (boolean) - default is on enable_partitionwise_join configuration parameter @@ -5491,7 +5491,7 @@ ANY num_sync ( - enable_partitionwise_aggregate (boolean) + enable_partitionwise_aggregate (boolean) - default is on enable_partitionwise_aggregate configuration parameter @@ -5516,7 +5516,7 @@ ANY num_sync ( - enable_presorted_aggregate (boolean) + enable_presorted_aggregate (boolean) - default is on enable_presorted_aggregate configuration parameter @@ -5539,7 +5539,7 @@ ANY num_sync ( - enable_seqscan (boolean) + enable_seqscan (boolean) - default is on sequential scan @@ -5559,7 +5559,7 @@ ANY num_sync ( - enable_sort (boolean) + enable_sort (boolean) - default is on enable_sort configuration parameter @@ -5576,7 +5576,7 @@ ANY num_sync ( - enable_tidscan (boolean) + enable_tidscan (boolean) - default is on enable_tidscan configuration parameter @@ -5619,7 +5619,7 @@ ANY num_sync ( - seq_page_cost (floating point) + seq_page_cost (floating point) - default is 1.0 seq_page_cost configuration parameter @@ -5636,7 +5636,7 @@ ANY num_sync ( - random_page_cost (floating point) + random_page_cost (floating point) - default is 4.0 random_page_cost configuration parameter @@ -5696,7 +5696,7 @@ ANY num_sync ( - cpu_tuple_cost (floating point) + cpu_tuple_cost (floating point) - default is 0.01 cpu_tuple_cost configuration parameter @@ -5711,7 +5711,7 @@ ANY num_sync ( - cpu_index_tuple_cost (floating point) + cpu_index_tuple_cost (floating point) - default is 0.005 cpu_index_tuple_cost configuration parameter @@ -5726,7 +5726,7 @@ ANY num_sync ( - cpu_operator_cost (floating point) + cpu_operator_cost (floating point) - default is 0.0025 cpu_operator_cost configuration parameter @@ -5741,7 +5741,7 @@ ANY num_sync ( - parallel_setup_cost (floating point) + parallel_setup_cost (floating point) - default is 1000 parallel_setup_cost configuration parameter @@ -5756,7 +5756,7 @@ ANY num_sync ( - parallel_tuple_cost (floating point) + parallel_tuple_cost (floating point) - default is 0.1 parallel_tuple_cost configuration parameter @@ -5771,7 +5771,7 @@ ANY num_sync ( - min_parallel_table_scan_size (integer) + min_parallel_table_scan_size (integer) - default is 8MB min_parallel_table_scan_size configuration parameter @@ -5791,7 +5791,7 @@ ANY num_sync ( - min_parallel_index_scan_size (integer) + min_parallel_index_scan_size (integer) - default is 512kb min_parallel_index_scan_size configuration parameter @@ -5813,7 +5813,7 @@ ANY num_sync ( - effective_cache_size (integer) + effective_cache_size (integer) - default is 4MB effective_cache_size configuration parameter @@ -5847,7 +5847,7 @@ ANY num_sync ( - jit_above_cost (floating point) + jit_above_cost (floating point) - default is 100000 jit_above_cost configuration parameter @@ -5865,7 +5865,7 @@ ANY num_sync ( - jit_inline_above_cost (floating point) + jit_inline_above_cost (floating point) - default is 500000 jit_inline_above_cost configuration parameter @@ -5883,7 +5883,7 @@ ANY num_sync ( - jit_optimize_above_cost (floating point) + jit_optimize_above_cost (floating point) - default is 500000 jit_optimize_above_cost configuration parameter @@ -5920,7 +5920,7 @@ ANY num_sync ( - geqo (boolean) + geqo (boolean) - default is on genetic query optimization @@ -5943,7 +5943,7 @@ ANY num_sync ( - geqo_threshold (integer) + geqo_threshold (integer) - default is 12 geqo_threshold configuration parameter @@ -5964,7 +5964,7 @@ ANY num_sync ( - geqo_effort (integer) + geqo_effort (integer) - default is 5 geqo_effort configuration parameter @@ -5990,7 +5990,7 @@ ANY num_sync ( - geqo_pool_size (integer) + geqo_pool_size (integer) - default is 0 geqo_pool_size configuration parameter @@ -6008,7 +6008,7 @@ ANY num_sync ( - geqo_generations (integer) + geqo_generations (integer) - default is 0 geqo_generations configuration parameter @@ -6026,7 +6026,7 @@ ANY num_sync ( - geqo_selection_bias (floating point) + geqo_selection_bias (floating point) - default is 2.00 geqo_selection_bias configuration parameter @@ -6041,7 +6041,7 @@ ANY num_sync ( - geqo_seed (floating point) + geqo_seed (floating point) - default is 1 geqo_seed configuration parameter @@ -6065,7 +6065,7 @@ ANY num_sync ( - default_statistics_target (integer) + default_statistics_target (integer) - default is 100 default_statistics_target configuration parameter @@ -6084,7 +6084,7 @@ ANY num_sync ( - constraint_exclusion (enum) + constraint_exclusion (enum) - default is partition constraint exclusion @@ -6145,7 +6145,7 @@ SELECT * FROM parent WHERE key = 2400; - cursor_tuple_fraction (floating point) + cursor_tuple_fraction (floating point) - default is 0.1 cursor_tuple_fraction configuration parameter @@ -6166,7 +6166,7 @@ SELECT * FROM parent WHERE key = 2400; - from_collapse_limit (integer) + from_collapse_limit (integer) - default is 8 from_collapse_limit configuration parameter @@ -6189,7 +6189,7 @@ SELECT * FROM parent WHERE key = 2400; - jit (boolean) + jit (boolean) - default is on jit configuration parameter @@ -6205,7 +6205,7 @@ SELECT * FROM parent WHERE key = 2400; - join_collapse_limit (integer) + join_collapse_limit (integer) - default is the same as from_collapse_limit join_collapse_limit configuration parameter @@ -6241,7 +6241,7 @@ SELECT * FROM parent WHERE key = 2400; - plan_cache_mode (enum) + plan_cache_mode (enum) - default is auto plan_cache_mode configuration parameter @@ -6269,7 +6269,7 @@ SELECT * FROM parent WHERE key = 2400; - recursive_worktable_factor (floating point) + recursive_worktable_factor (floating point) - default is 10.0 recursive_worktable_factor configuration parameter @@ -6454,7 +6454,7 @@ local0.* /var/log/postgresql - log_directory (string) + log_directory (string) - default is log log_directory configuration parameter @@ -6473,7 +6473,7 @@ local0.* /var/log/postgresql - log_filename (string) + log_filename (string) - default is postgresql-%Y-%m-%d_%H%M%S.log log_filename configuration parameter @@ -6527,7 +6527,7 @@ local0.* /var/log/postgresql - log_file_mode (integer) + log_file_mode (integer) - default is 0600 log_file_mode configuration parameter @@ -6561,7 +6561,7 @@ local0.* /var/log/postgresql - log_rotation_age (integer) + log_rotation_age (integer) - default is 24hours log_rotation_age configuration parameter @@ -6581,7 +6581,7 @@ local0.* /var/log/postgresql - log_rotation_size (integer) + log_rotation_size (integer) - default is 10MB log_rotation_size configuration parameter @@ -6645,7 +6645,7 @@ local0.* /var/log/postgresql - syslog_facility (enum) + syslog_facility (enum) - default is LOCAL0 syslog_facility configuration parameter @@ -6668,7 +6668,7 @@ local0.* /var/log/postgresql - syslog_ident (string) + syslog_ident (string) - default is postgres syslog_ident configuration parameter @@ -6687,7 +6687,7 @@ local0.* /var/log/postgresql - syslog_sequence_numbers (boolean) + syslog_sequence_numbers (boolean) - default is on syslog_sequence_numbers configuration parameter @@ -6715,7 +6715,7 @@ local0.* /var/log/postgresql - syslog_split_messages (boolean) + syslog_split_messages (boolean) - default is on syslog_split_messages configuration parameter @@ -6748,7 +6748,7 @@ local0.* /var/log/postgresql - event_source (string) + event_source (string) - default is PostgreSQL event_source configuration parameter @@ -6773,7 +6773,7 @@ local0.* /var/log/postgresql - log_min_messages (enum) + log_min_messages (enum) - default is WARNING log_min_messages configuration parameter @@ -6798,7 +6798,7 @@ local0.* /var/log/postgresql - log_min_error_statement (enum) + log_min_error_statement (enum) - default is ERROR log_min_error_statement configuration parameter @@ -6829,7 +6829,7 @@ local0.* /var/log/postgresql - log_min_duration_statement (integer) + log_min_duration_statement (integer) - default is -1 log_min_duration_statement configuration parameter @@ -6879,7 +6879,7 @@ local0.* /var/log/postgresql - log_min_duration_sample (integer) + log_min_duration_sample (integer) - default is -1 log_min_duration_sample configuration parameter @@ -6920,7 +6920,7 @@ local0.* /var/log/postgresql - log_statement_sample_rate (floating point) + log_statement_sample_rate (floating point) - default is 1.0 log_statement_sample_rate configuration parameter @@ -6945,7 +6945,7 @@ local0.* /var/log/postgresql - log_transaction_sample_rate (floating point) + log_transaction_sample_rate (floating point) - default is 0 log_transaction_sample_rate configuration parameter @@ -6976,7 +6976,7 @@ local0.* /var/log/postgresql - log_startup_progress_interval (integer) + log_startup_progress_interval (integer) - default is 10 seconds log_startup_progress_interval configuration parameter @@ -7144,7 +7144,7 @@ local0.* /var/log/postgresql debug_print_rewritten configuration parameter - debug_print_plan (boolean) + debug_print_plan (boolean) - default is off debug_print_plan configuration parameter @@ -7165,7 +7165,7 @@ local0.* /var/log/postgresql - debug_pretty_print (boolean) + debug_pretty_print (boolean) - default is on debug_pretty_print configuration parameter @@ -7183,7 +7183,7 @@ local0.* /var/log/postgresql - log_autovacuum_min_duration (integer) + log_autovacuum_min_duration (integer) - default is 10 minutes log_autovacuum_min_duration configuration parameter @@ -7210,7 +7210,7 @@ local0.* /var/log/postgresql - log_checkpoints (boolean) + log_checkpoints (boolean) - default is on log_checkpoints configuration parameter @@ -7227,7 +7227,7 @@ local0.* /var/log/postgresql - log_connections (boolean) + log_connections (boolean) - default is off log_connections configuration parameter @@ -7255,7 +7255,7 @@ local0.* /var/log/postgresql - log_disconnections (boolean) + log_disconnections (boolean) - default is off log_disconnections configuration parameter @@ -7275,7 +7275,7 @@ local0.* /var/log/postgresql - log_duration (boolean) + log_duration (boolean) - default is off log_duration configuration parameter @@ -7310,7 +7310,7 @@ local0.* /var/log/postgresql - log_error_verbosity (enum) + log_error_verbosity (enum) - default is DEFAULT log_error_verbosity configuration parameter @@ -7573,7 +7573,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' - log_lock_waits (boolean) + log_lock_waits (boolean) - default is off log_lock_waits configuration parameter @@ -7591,7 +7591,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' - log_recovery_conflict_waits (boolean) + log_recovery_conflict_waits (boolean) - default is off log_recovery_conflict_waits configuration parameter @@ -7613,7 +7613,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' - log_parameter_max_length (integer) + log_parameter_max_length (integer) - default is -1 log_parameter_max_length configuration parameter @@ -7641,7 +7641,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' - log_parameter_max_length_on_error (integer) + log_parameter_max_length_on_error (integer) - default is 0 log_parameter_max_length_on_error configuration parameter @@ -7669,7 +7669,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' - log_statement (enum) + log_statement (enum) - default is none log_statement configuration parameter @@ -7719,7 +7719,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' - log_replication_commands (boolean) + log_replication_commands (boolean) - default is off log_replication_commands configuration parameter @@ -7737,7 +7737,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' - log_temp_files (integer) + log_temp_files (integer) - default is -1 log_temp_files configuration parameter @@ -7761,7 +7761,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a ' - log_timezone (string) + log_timezone (string) - default is GMT log_timezone configuration parameter @@ -8152,7 +8152,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - update_process_title (boolean) + update_process_title (boolean) - default is off update_process_title configuration parameter @@ -8190,7 +8190,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_activities (boolean) + track_activities (boolean) - default is on track_activities configuration parameter @@ -8212,7 +8212,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_activity_query_size (integer) + track_activity_query_size (integer) - default is 1024 bytes track_activity_query_size configuration parameter @@ -8230,7 +8230,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_counts (boolean) + track_counts (boolean) - default is on track_counts configuration parameter @@ -8247,7 +8247,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_io_timing (boolean) + track_io_timing (boolean) - default is off track_io_timing configuration parameter @@ -8279,7 +8279,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_wal_io_timing (boolean) + track_wal_io_timing (boolean) - default is off track_wal_io_timing configuration parameter @@ -8301,7 +8301,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - track_functions (enum) + track_functions (enum) - default is none track_functions configuration parameter @@ -8328,7 +8328,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - stats_fetch_consistency (enum) + stats_fetch_consistency (enum) - default is cache stats_fetch_consistency configuration parameter @@ -8370,7 +8370,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - compute_query_id (enum) + compute_query_id (enum) - default is auto compute_query_id configuration parameter @@ -8407,22 +8407,22 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - log_statement_stats (boolean) + log_statement_stats (boolean) - default is off log_statement_stats configuration parameter - log_parser_stats (boolean) + log_parser_stats (boolean) - default is off log_parser_stats configuration parameter - log_planner_stats (boolean) + log_planner_stats (boolean) - default is off log_planner_stats configuration parameter - log_executor_stats (boolean) + log_executor_stats (boolean) - default is off log_executor_stats configuration parameter @@ -8474,7 +8474,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum (boolean) + autovacuum (boolean) - default is on autovacuum configuration parameter @@ -8519,7 +8519,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_max_workers (integer) + autovacuum_max_workers (integer) - default is 3 autovacuum_max_workers configuration parameter @@ -8541,7 +8541,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_naptime (integer) + autovacuum_naptime (integer) - default is 1 minute autovacuum_naptime configuration parameter @@ -8561,7 +8561,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_threshold (integer) + autovacuum_vacuum_threshold (integer) - default is 50 tuples autovacuum_vacuum_threshold configuration parameter @@ -8581,7 +8581,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_insert_threshold (integer) + autovacuum_vacuum_insert_threshold (integer) - default is 1000 tuples autovacuum_vacuum_insert_threshold configuration parameter @@ -8603,7 +8603,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_analyze_threshold (integer) + autovacuum_analyze_threshold (integer) - default is 50 tuples autovacuum_analyze_threshold configuration parameter @@ -8623,7 +8623,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_scale_factor (floating point) + autovacuum_vacuum_scale_factor (floating point) - default is 0.2 autovacuum_vacuum_scale_factor configuration parameter @@ -8644,7 +8644,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_insert_scale_factor (floating point) + autovacuum_vacuum_insert_scale_factor (floating point) - default is 0.2 autovacuum_vacuum_insert_scale_factor configuration parameter @@ -8665,7 +8665,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_analyze_scale_factor (floating point) + autovacuum_analyze_scale_factor (floating point) - default is 0.1 autovacuum_analyze_scale_factor configuration parameter @@ -8744,7 +8744,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_cost_delay (floating point) + autovacuum_vacuum_cost_delay (floating point) - default is 2 miliseconds autovacuum_vacuum_cost_delay configuration parameter @@ -8766,7 +8766,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - autovacuum_vacuum_cost_limit (integer) + autovacuum_vacuum_cost_limit (integer) - default is -1 autovacuum_vacuum_cost_limit configuration parameter @@ -8829,7 +8829,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_cost_delay (floating point) + vacuum_cost_delay (floating point) - default is 0 vacuum_cost_delay configuration parameter @@ -8859,7 +8859,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_cost_page_hit (integer) + vacuum_cost_page_hit (integer) - default is 1 vacuum_cost_page_hit configuration parameter @@ -8875,7 +8875,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_cost_page_miss (integer) + vacuum_cost_page_miss (integer) - default is 2 vacuum_cost_page_miss configuration parameter @@ -8892,7 +8892,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_cost_page_dirty (integer) + vacuum_cost_page_dirty (integer) - default is 20 vacuum_cost_page_dirty configuration parameter @@ -8908,7 +8908,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; - vacuum_cost_limit (integer) + vacuum_cost_limit (integer) - default is 200 vacuum_cost_limit configuration parameter