public inbox for [email protected]
help / color / mirror / Atom feedFrom: Marcos Pegoraro <[email protected]>
To: PostgreSQL Hackers <[email protected]>
Subject: Better visualization of default values
Date: Wed, 5 Feb 2025 18:07:13 -0300
Message-ID: <CAB-JLwZ5h=my4eeqe0KM=K6hR66nsA1Wea0ATQAt=Shh_Ji2pw@mail.gmail.com> (raw)
Reading DOCs sometimes is boring because you want to know only the default
value of something. I know what that GUC is, I know how to change it, I
only don't remember what its default value is. Then you have to read that
entire paragraph just to read that the default value is ...
So, what you think about this.
It's not complete but you can see if it's useful or not
regards
Marcos
Attachments:
[application/octet-stream] patch.diff (108.0K, ../CAB-JLwZ5h=my4eeqe0KM=K6hR66nsA1Wea0ATQAt=Shh_Ji2pw@mail.gmail.com/3-patch.diff)
download | inline diff:
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'
<variablelist>
<varlistentry id="guc-listen-addresses" xreflabel="listen_addresses">
- <term><varname>listen_addresses</varname> (<type>string</type>)
+ <term><varname>listen_addresses</varname> (<type>string</type>) - default is localhost
<indexterm>
<primary><varname>listen_addresses</varname> configuration parameter</primary>
</indexterm>
@@ -678,7 +678,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-port" xreflabel="port">
- <term><varname>port</varname> (<type>integer</type>)
+ <term><varname>port</varname> (<type>integer</type>) - default is 5432
<indexterm>
<primary><varname>port</varname> configuration parameter</primary>
</indexterm>
@@ -693,7 +693,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-connections" xreflabel="max_connections">
- <term><varname>max_connections</varname> (<type>integer</type>)
+ <term><varname>max_connections</varname> (<type>integer</type>) - default is 100
<indexterm>
<primary><varname>max_connections</varname> configuration parameter</primary>
</indexterm>
@@ -722,7 +722,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-reserved-connections" xreflabel="reserved_connections">
- <term><varname>reserved_connections</varname> (<type>integer</type>)
+ <term><varname>reserved_connections</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>reserved_connections</varname> configuration parameter</primary>
</indexterm>
@@ -755,7 +755,7 @@ include_dir 'conf.d'
<varlistentry id="guc-superuser-reserved-connections"
xreflabel="superuser_reserved_connections">
<term><varname>superuser_reserved_connections</varname>
- (<type>integer</type>)
+ (<type>integer</type>) - default is 3
<indexterm>
<primary><varname>superuser_reserved_connections</varname> configuration parameter</primary>
</indexterm>
@@ -785,7 +785,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-unix-socket-directories" xreflabel="unix_socket_directories">
- <term><varname>unix_socket_directories</varname> (<type>string</type>)
+ <term><varname>unix_socket_directories</varname> (<type>string</type>) - default is /tmp, on Windows is an empty string
<indexterm>
<primary><varname>unix_socket_directories</varname> configuration parameter</primary>
</indexterm>
@@ -836,7 +836,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-unix-socket-group" xreflabel="unix_socket_group">
- <term><varname>unix_socket_group</varname> (<type>string</type>)
+ <term><varname>unix_socket_group</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>unix_socket_group</varname> configuration parameter</primary>
</indexterm>
@@ -862,7 +862,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-unix-socket-permissions" xreflabel="unix_socket_permissions">
- <term><varname>unix_socket_permissions</varname> (<type>integer</type>)
+ <term><varname>unix_socket_permissions</varname> (<type>integer</type>) - default is 0777
<indexterm>
<primary><varname>unix_socket_permissions</varname> configuration parameter</primary>
</indexterm>
@@ -912,7 +912,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-bonjour" xreflabel="bonjour">
- <term><varname>bonjour</varname> (<type>boolean</type>)
+ <term><varname>bonjour</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>bonjour</varname> configuration parameter</primary>
</indexterm>
@@ -927,7 +927,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-bonjour-name" xreflabel="bonjour_name">
- <term><varname>bonjour_name</varname> (<type>string</type>)
+ <term><varname>bonjour_name</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>bonjour_name</varname> configuration parameter</primary>
</indexterm>
@@ -952,7 +952,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-tcp-keepalives-idle" xreflabel="tcp_keepalives_idle">
- <term><varname>tcp_keepalives_idle</varname> (<type>integer</type>)
+ <term><varname>tcp_keepalives_idle</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>tcp_keepalives_idle</varname> configuration parameter</primary>
</indexterm>
@@ -975,7 +975,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-tcp-keepalives-interval" xreflabel="tcp_keepalives_interval">
- <term><varname>tcp_keepalives_interval</varname> (<type>integer</type>)
+ <term><varname>tcp_keepalives_interval</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>tcp_keepalives_interval</varname> configuration parameter</primary>
</indexterm>
@@ -998,7 +998,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-tcp-keepalives-count" xreflabel="tcp_keepalives_count">
- <term><varname>tcp_keepalives_count</varname> (<type>integer</type>)
+ <term><varname>tcp_keepalives_count</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>tcp_keepalives_count</varname> configuration parameter</primary>
</indexterm>
@@ -1018,7 +1018,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-tcp-user-timeout" xreflabel="tcp_user_timeout">
- <term><varname>tcp_user_timeout</varname> (<type>integer</type>)
+ <term><varname>tcp_user_timeout</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>tcp_user_timeout</varname> configuration parameter</primary>
</indexterm>
@@ -1038,7 +1038,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-client-connection-check-interval" xreflabel="client_connection_check_interval">
- <term><varname>client_connection_check_interval</varname> (<type>integer</type>)
+ <term><varname>client_connection_check_interval</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>client_connection_check_interval</varname> configuration parameter</primary>
</indexterm>
@@ -1082,7 +1082,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-authentication-timeout" xreflabel="authentication_timeout">
- <term><varname>authentication_timeout</varname> (<type>integer</type>)
+ <term><varname>authentication_timeout</varname> (<type>integer</type>) - default is 1m
<indexterm><primary>timeout</primary><secondary>client authentication</secondary></indexterm>
<indexterm><primary>client authentication</primary><secondary>timeout during</secondary></indexterm>
<indexterm>
@@ -1105,7 +1105,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-password-encryption" xreflabel="password_encryption">
- <term><varname>password_encryption</varname> (<type>enum</type>)
+ <term><varname>password_encryption</varname> (<type>enum</type>) - default is scram-sha-256
<indexterm>
<primary><varname>password_encryption</varname> configuration parameter</primary>
</indexterm>
@@ -1136,7 +1136,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-scram-iterations" xreflabel="scram_iterations">
- <term><varname>scram_iterations</varname> (<type>integer</type>)
+ <term><varname>scram_iterations</varname> (<type>integer</type>) - default is 4096
<indexterm>
<primary><varname>scram_iterations</varname> configuration parameter</primary>
</indexterm>
@@ -1156,7 +1156,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-krb-server-keyfile" xreflabel="krb_server_keyfile">
- <term><varname>krb_server_keyfile</varname> (<type>string</type>)
+ <term><varname>krb_server_keyfile</varname> (<type>string</type>) - default is FILE:/usr/local/pgsql/etc/krb5.keytab
<indexterm>
<primary><varname>krb_server_keyfile</varname> configuration parameter</primary>
</indexterm>
@@ -1178,7 +1178,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-krb-caseins-users" xreflabel="krb_caseins_users">
- <term><varname>krb_caseins_users</varname> (<type>boolean</type>)
+ <term><varname>krb_caseins_users</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>krb_caseins_users</varname> configuration parameter</primary>
</indexterm>
@@ -1194,7 +1194,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-gss-accept-delegation" xreflabel="gss_accept_delegation">
- <term><varname>gss_accept_delegation</varname> (<type>boolean</type>)
+ <term><varname>gss_accept_delegation</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>gss_accept_delegation</varname> configuration parameter</primary>
</indexterm>
@@ -1227,7 +1227,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-ssl" xreflabel="ssl">
- <term><varname>ssl</varname> (<type>boolean</type>)
+ <term><varname>ssl</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>ssl</varname> configuration parameter</primary>
</indexterm>
@@ -1243,7 +1243,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-ca-file" xreflabel="ssl_ca_file">
- <term><varname>ssl_ca_file</varname> (<type>string</type>)
+ <term><varname>ssl_ca_file</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>ssl_ca_file</varname> configuration parameter</primary>
</indexterm>
@@ -1262,7 +1262,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-cert-file" xreflabel="ssl_cert_file">
- <term><varname>ssl_cert_file</varname> (<type>string</type>)
+ <term><varname>ssl_cert_file</varname> (<type>string</type>) - default is server.crt
<indexterm>
<primary><varname>ssl_cert_file</varname> configuration parameter</primary>
</indexterm>
@@ -1279,7 +1279,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-crl-file" xreflabel="ssl_crl_file">
- <term><varname>ssl_crl_file</varname> (<type>string</type>)
+ <term><varname>ssl_crl_file</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>ssl_crl_file</varname> configuration parameter</primary>
</indexterm>
@@ -1298,7 +1298,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-crl-dir" xreflabel="ssl_crl_dir">
- <term><varname>ssl_crl_dir</varname> (<type>string</type>)
+ <term><varname>ssl_crl_dir</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>ssl_crl_dir</varname> configuration parameter</primary>
</indexterm>
@@ -1332,7 +1332,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-key-file" xreflabel="ssl_key_file">
- <term><varname>ssl_key_file</varname> (<type>string</type>)
+ <term><varname>ssl_key_file</varname> (<type>string</type>) - default is server.key
<indexterm>
<primary><varname>ssl_key_file</varname> configuration parameter</primary>
</indexterm>
@@ -1349,7 +1349,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-tls13-ciphers" xreflabel="ssl_tls13_ciphers">
- <term><varname>ssl_tls13_ciphers</varname> (<type>string</type>)
+ <term><varname>ssl_tls13_ciphers</varname> (<type>string</type>) - default is HIGH:MEDIUM:+3DES:!aNULL
<indexterm>
<primary><varname>ssl_tls13_ciphers</varname> configuration parameter</primary>
</indexterm>
@@ -1371,7 +1371,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-ciphers" xreflabel="ssl_ciphers">
- <term><varname>ssl_ciphers</varname> (<type>string</type>)
+ <term><varname>ssl_ciphers</varname> (<type>string</type>) - default is HIGH:MEDIUM:+3DES:!aNULL
<indexterm>
<primary><varname>ssl_ciphers</varname> configuration parameter</primary>
</indexterm>
@@ -1456,7 +1456,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-prefer-server-ciphers" xreflabel="ssl_prefer_server_ciphers">
- <term><varname>ssl_prefer_server_ciphers</varname> (<type>boolean</type>)
+ <term><varname>ssl_prefer_server_ciphers</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>ssl_prefer_server_ciphers</varname> configuration parameter</primary>
</indexterm>
@@ -1481,7 +1481,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-groups" xreflabel="ssl_groups">
- <term><varname>ssl_groups</varname> (<type>string</type>)
+ <term><varname>ssl_groups</varname> (<type>string</type>) - default is prime256v1
<indexterm>
<primary><varname>ssl_groups</varname> configuration parameter</primary>
</indexterm>
@@ -1518,7 +1518,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-min-protocol-version" xreflabel="ssl_min_protocol_version">
- <term><varname>ssl_min_protocol_version</varname> (<type>enum</type>)
+ <term><varname>ssl_min_protocol_version</varname> (<type>enum</type>) - default is TLSv1.2
<indexterm>
<primary><varname>ssl_min_protocol_version</varname> configuration parameter</primary>
</indexterm>
@@ -1547,7 +1547,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-max-protocol-version" xreflabel="ssl_max_protocol_version">
- <term><varname>ssl_max_protocol_version</varname> (<type>enum</type>)
+ <term><varname>ssl_max_protocol_version</varname> (<type>enum</type>) - default is to allow any version
<indexterm>
<primary><varname>ssl_max_protocol_version</varname> configuration parameter</primary>
</indexterm>
@@ -1570,7 +1570,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-dh-params-file" xreflabel="ssl_dh_params_file">
- <term><varname>ssl_dh_params_file</varname> (<type>string</type>)
+ <term><varname>ssl_dh_params_file</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>ssl_dh_params_file</varname> configuration parameter</primary>
</indexterm>
@@ -1594,7 +1594,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-passphrase-command" xreflabel="ssl_passphrase_command">
- <term><varname>ssl_passphrase_command</varname> (<type>string</type>)
+ <term><varname>ssl_passphrase_command</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>ssl_passphrase_command</varname> configuration parameter</primary>
</indexterm>
@@ -1628,7 +1628,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-ssl-passphrase-command-supports-reload" xreflabel="ssl_passphrase_command_supports_reload">
- <term><varname>ssl_passphrase_command_supports_reload</varname> (<type>boolean</type>)
+ <term><varname>ssl_passphrase_command_supports_reload</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>ssl_passphrase_command_supports_reload</varname> configuration parameter</primary>
</indexterm>
@@ -1664,7 +1664,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-shared-buffers" xreflabel="shared_buffers">
- <term><varname>shared_buffers</varname> (<type>integer</type>)
+ <term><varname>shared_buffers</varname> (<type>integer</type>) - default is 128MB
<indexterm>
<primary><varname>shared_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -1709,7 +1709,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-huge-pages" xreflabel="huge_pages">
- <term><varname>huge_pages</varname> (<type>enum</type>)
+ <term><varname>huge_pages</varname> (<type>enum</type>) - default is try
<indexterm>
<primary><varname>huge_pages</varname> configuration parameter</primary>
</indexterm>
@@ -1772,7 +1772,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-huge-page-size" xreflabel="huge_page_size">
- <term><varname>huge_page_size</varname> (<type>integer</type>)
+ <term><varname>huge_page_size</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>huge_page_size</varname> configuration parameter</primary>
</indexterm>
@@ -1799,7 +1799,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-temp-buffers" xreflabel="temp_buffers">
- <term><varname>temp_buffers</varname> (<type>integer</type>)
+ <term><varname>temp_buffers</varname> (<type>integer</type>) - default is 8MB
<indexterm>
<primary><varname>temp_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -1833,7 +1833,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-prepared-transactions" xreflabel="max_prepared_transactions">
- <term><varname>max_prepared_transactions</varname> (<type>integer</type>)
+ <term><varname>max_prepared_transactions</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>max_prepared_transactions</varname> configuration parameter</primary>
</indexterm>
@@ -1866,7 +1866,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-work-mem" xreflabel="work_mem">
- <term><varname>work_mem</varname> (<type>integer</type>)
+ <term><varname>work_mem</varname> (<type>integer</type>) - default is 4MB
<indexterm>
<primary><varname>work_mem</varname> configuration parameter</primary>
</indexterm>
@@ -1905,7 +1905,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-hash-mem-multiplier" xreflabel="hash_mem_multiplier">
- <term><varname>hash_mem_multiplier</varname> (<type>floating point</type>)
+ <term><varname>hash_mem_multiplier</varname> (<type>floating point</type>) - default is 2.0
<indexterm>
<primary><varname>hash_mem_multiplier</varname> configuration parameter</primary>
</indexterm>
@@ -1935,7 +1935,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-maintenance-work-mem" xreflabel="maintenance_work_mem">
- <term><varname>maintenance_work_mem</varname> (<type>integer</type>)
+ <term><varname>maintenance_work_mem</varname> (<type>integer</type>) - default is 64MB
<indexterm>
<primary><varname>maintenance_work_mem</varname> configuration parameter</primary>
</indexterm>
@@ -1965,7 +1965,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-autovacuum-work-mem" xreflabel="autovacuum_work_mem">
- <term><varname>autovacuum_work_mem</varname> (<type>integer</type>)
+ <term><varname>autovacuum_work_mem</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>autovacuum_work_mem</varname> configuration parameter</primary>
</indexterm>
@@ -1988,7 +1988,7 @@ include_dir 'conf.d'
<varlistentry id="guc-vacuum-buffer-usage-limit" xreflabel="vacuum_buffer_usage_limit">
<term>
- <varname>vacuum_buffer_usage_limit</varname> (<type>integer</type>)
+ <varname>vacuum_buffer_usage_limit</varname> (<type>integer</type>) - default is 2MB
<indexterm>
<primary><varname>vacuum_buffer_usage_limit</varname> configuration parameter</primary>
</indexterm>
@@ -2017,7 +2017,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-logical-decoding-work-mem" xreflabel="logical_decoding_work_mem">
- <term><varname>logical_decoding_work_mem</varname> (<type>integer</type>)
+ <term><varname>logical_decoding_work_mem</varname> (<type>integer</type>) - default is 64MB
<indexterm>
<primary><varname>logical_decoding_work_mem</varname> configuration parameter</primary>
</indexterm>
@@ -2038,7 +2038,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-commit-timestamp-buffers" xreflabel="commit_timestamp_buffers">
- <term><varname>commit_timestamp_buffers</varname> (<type>integer</type>)
+ <term><varname>commit_timestamp_buffers</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>commit_timestamp_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -2059,7 +2059,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-multixact-member-buffers" xreflabel="multixact_member_buffers">
- <term><varname>multixact_member_buffers</varname> (<type>integer</type>)
+ <term><varname>multixact_member_buffers</varname> (<type>integer</type>) - default is 32
<indexterm>
<primary><varname>multixact_member_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -2078,7 +2078,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-multixact-offset-buffers" xreflabel="multixact_offset_buffers">
- <term><varname>multixact_offset_buffers</varname> (<type>integer</type>)
+ <term><varname>multixact_offset_buffers</varname> (<type>integer</type>) - default is 16
<indexterm>
<primary><varname>multixact_offset_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -2097,7 +2097,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-notify-buffers" xreflabel="notify_buffers">
- <term><varname>notify_buffers</varname> (<type>integer</type>)
+ <term><varname>notify_buffers</varname> (<type>integer</type>) - default is 16
<indexterm>
<primary><varname>notify_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -2116,7 +2116,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-serializable-buffers" xreflabel="serializable_buffers">
- <term><varname>serializable_buffers</varname> (<type>integer</type>)
+ <term><varname>serializable_buffers</varname> (<type>integer</type>) - default is 32
<indexterm>
<primary><varname>serializable_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -2135,7 +2135,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-subtransaction-buffers" xreflabel="subtransaction_buffers">
- <term><varname>subtransaction_buffers</varname> (<type>integer</type>)
+ <term><varname>subtransaction_buffers</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>subtransaction_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -2156,7 +2156,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-transaction-buffers" xreflabel="transaction_buffers">
- <term><varname>transaction_buffers</varname> (<type>integer</type>)
+ <term><varname>transaction_buffers</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>transaction_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -2177,7 +2177,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-stack-depth" xreflabel="max_stack_depth">
- <term><varname>max_stack_depth</varname> (<type>integer</type>)
+ <term><varname>max_stack_depth</varname> (<type>integer</type>) - default is 2MB
<indexterm>
<primary><varname>max_stack_depth</varname> configuration parameter</primary>
</indexterm>
@@ -2211,7 +2211,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-shared-memory-type" xreflabel="shared_memory_type">
- <term><varname>shared_memory_type</varname> (<type>enum</type>)
+ <term><varname>shared_memory_type</varname> (<type>enum</type>) - default is first supported option for that platform
<indexterm>
<primary><varname>shared_memory_type</varname> configuration parameter</primary>
</indexterm>
@@ -2236,7 +2236,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-dynamic-shared-memory-type" xreflabel="dynamic_shared_memory_type">
- <term><varname>dynamic_shared_memory_type</varname> (<type>enum</type>)
+ <term><varname>dynamic_shared_memory_type</varname> (<type>enum</type>) - default is first supported option for that platform
<indexterm>
<primary><varname>dynamic_shared_memory_type</varname> configuration parameter</primary>
</indexterm>
@@ -2263,7 +2263,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-min-dynamic-shared-memory" xreflabel="min_dynamic_shared_memory">
- <term><varname>min_dynamic_shared_memory</varname> (<type>integer</type>)
+ <term><varname>min_dynamic_shared_memory</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>min_dynamic_shared_memory</varname> configuration parameter</primary>
</indexterm>
@@ -2295,7 +2295,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-temp-file-limit" xreflabel="temp_file_limit">
- <term><varname>temp_file_limit</varname> (<type>integer</type>)
+ <term><varname>temp_file_limit</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>temp_file_limit</varname> configuration parameter</primary>
</indexterm>
@@ -2322,7 +2322,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-notify-queue-pages" xreflabel="max_notify_queue_pages">
- <term><varname>max_notify_queue_pages</varname> (<type>integer</type>)
+ <term><varname>max_notify_queue_pages</varname> (<type>integer</type>) - default is 1048576
<indexterm>
<primary><varname>max_notify_queue_pages</varname> configuration parameter</primary>
</indexterm>
@@ -2345,7 +2345,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-max-files-per-process" xreflabel="max_files_per_process">
- <term><varname>max_files_per_process</varname> (<type>integer</type>)
+ <term><varname>max_files_per_process</varname> (<type>integer</type>) - default is 1000 files
<indexterm>
<primary><varname>max_files_per_process</varname> configuration parameter</primary>
</indexterm>
@@ -2390,7 +2390,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-bgwriter-delay" xreflabel="bgwriter_delay">
- <term><varname>bgwriter_delay</varname> (<type>integer</type>)
+ <term><varname>bgwriter_delay</varname> (<type>integer</type>) - default is 200ms
<indexterm>
<primary><varname>bgwriter_delay</varname> configuration parameter</primary>
</indexterm>
@@ -2418,7 +2418,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-bgwriter-lru-maxpages" xreflabel="bgwriter_lru_maxpages">
- <term><varname>bgwriter_lru_maxpages</varname> (<type>integer</type>)
+ <term><varname>bgwriter_lru_maxpages</varname> (<type>integer</type>) - default is 100 buffers
<indexterm>
<primary><varname>bgwriter_lru_maxpages</varname> configuration parameter</primary>
</indexterm>
@@ -2437,7 +2437,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-bgwriter-lru-multiplier" xreflabel="bgwriter_lru_multiplier">
- <term><varname>bgwriter_lru_multiplier</varname> (<type>floating point</type>)
+ <term><varname>bgwriter_lru_multiplier</varname> (<type>floating point</type>) - default is 2.0
<indexterm>
<primary><varname>bgwriter_lru_multiplier</varname> configuration parameter</primary>
</indexterm>
@@ -2465,7 +2465,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-bgwriter-flush-after" xreflabel="bgwriter_flush_after">
- <term><varname>bgwriter_flush_after</varname> (<type>integer</type>)
+ <term><varname>bgwriter_flush_after</varname> (<type>integer</type>) - default is 512kB on Linux, 0 elsewhere
<indexterm>
<primary><varname>bgwriter_flush_after</varname> configuration parameter</primary>
</indexterm>
@@ -2511,7 +2511,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-backend-flush-after" xreflabel="backend_flush_after">
- <term><varname>backend_flush_after</varname> (<type>integer</type>)
+ <term><varname>backend_flush_after</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>backend_flush_after</varname> configuration parameter</primary>
</indexterm>
@@ -2541,7 +2541,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-effective-io-concurrency" xreflabel="effective_io_concurrency">
- <term><varname>effective_io_concurrency</varname> (<type>integer</type>)
+ <term><varname>effective_io_concurrency</varname> (<type>integer</type>) - default is 1 on supported systems, otherwise 0
<indexterm>
<primary><varname>effective_io_concurrency</varname> configuration parameter</primary>
</indexterm>
@@ -2586,7 +2586,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-maintenance-io-concurrency" xreflabel="maintenance_io_concurrency">
- <term><varname>maintenance_io_concurrency</varname> (<type>integer</type>)
+ <term><varname>maintenance_io_concurrency</varname> (<type>integer</type>) - default is 10 on supported systems, otherwise 0
<indexterm>
<primary><varname>maintenance_io_concurrency</varname> configuration parameter</primary>
</indexterm>
@@ -2606,7 +2606,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-io-combine-limit" xreflabel="io_combine_limit">
- <term><varname>io_combine_limit</varname> (<type>integer</type>)
+ <term><varname>io_combine_limit</varname> (<type>integer</type>) - default is 128kb
<indexterm>
<primary><varname>io_combine_limit</varname> configuration parameter</primary>
</indexterm>
@@ -2620,7 +2620,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-worker-processes" xreflabel="max_worker_processes">
- <term><varname>max_worker_processes</varname> (<type>integer</type>)
+ <term><varname>max_worker_processes</varname> (<type>integer</type>) - default is 8
<indexterm>
<primary><varname>max_worker_processes</varname> configuration parameter</primary>
</indexterm>
@@ -2648,7 +2648,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-parallel-workers-per-gather" xreflabel="max_parallel_workers_per_gather">
- <term><varname>max_parallel_workers_per_gather</varname> (<type>integer</type>)
+ <term><varname>max_parallel_workers_per_gather</varname> (<type>integer</type>) - default is 2
<indexterm>
<primary><varname>max_parallel_workers_per_gather</varname> configuration parameter</primary>
</indexterm>
@@ -2690,7 +2690,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-parallel-maintenance-workers" xreflabel="max_parallel_maintenance_workers">
- <term><varname>max_parallel_maintenance_workers</varname> (<type>integer</type>)
+ <term><varname>max_parallel_maintenance_workers</varname> (<type>integer</type>) - default is 2
<indexterm>
<primary><varname>max_parallel_maintenance_workers</varname> configuration parameter</primary>
</indexterm>
@@ -2728,7 +2728,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-parallel-workers" xreflabel="max_parallel_workers">
- <term><varname>max_parallel_workers</varname> (<type>integer</type>)
+ <term><varname>max_parallel_workers</varname> (<type>integer</type>) - default is 8
<indexterm>
<primary><varname>max_parallel_workers</varname> configuration parameter</primary>
</indexterm>
@@ -2750,7 +2750,7 @@ include_dir 'conf.d'
<varlistentry id="guc-parallel-leader-participation" xreflabel="parallel_leader_participation">
<term>
- <varname>parallel_leader_participation</varname> (<type>boolean</type>)
+ <varname>parallel_leader_participation</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>parallel_leader_participation</varname> configuration parameter</primary>
</indexterm>
@@ -2787,7 +2787,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-wal-level" xreflabel="wal_level">
- <term><varname>wal_level</varname> (<type>enum</type>)
+ <term><varname>wal_level</varname> (<type>enum</type>) - default is replica
<indexterm>
<primary><varname>wal_level</varname> configuration parameter</primary>
</indexterm>
@@ -2910,7 +2910,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-synchronous-commit" xreflabel="synchronous_commit">
- <term><varname>synchronous_commit</varname> (<type>enum</type>)
+ <term><varname>synchronous_commit</varname> (<type>enum</type>) - default is on
<indexterm>
<primary><varname>synchronous_commit</varname> configuration parameter</primary>
</indexterm>
@@ -3065,7 +3065,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-sync-method" xreflabel="wal_sync_method">
- <term><varname>wal_sync_method</varname> (<type>enum</type>)
+ <term><varname>wal_sync_method</varname> (<type>enum</type>) - default is the first method supported by the platform
<indexterm>
<primary><varname>wal_sync_method</varname> configuration parameter</primary>
</indexterm>
@@ -3120,7 +3120,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-full-page-writes" xreflabel="full_page_writes">
- <term><varname>full_page_writes</varname> (<type>boolean</type>)
+ <term><varname>full_page_writes</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>full_page_writes</varname> configuration parameter</primary>
</indexterm>
@@ -3167,7 +3167,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-log-hints" xreflabel="wal_log_hints">
- <term><varname>wal_log_hints</varname> (<type>boolean</type>)
+ <term><varname>wal_log_hints</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>wal_log_hints</varname> configuration parameter</primary>
</indexterm>
@@ -3194,7 +3194,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-compression" xreflabel="wal_compression">
- <term><varname>wal_compression</varname> (<type>enum</type>)
+ <term><varname>wal_compression</varname> (<type>enum</type>) - default is off
<indexterm>
<primary><varname>wal_compression</varname> configuration parameter</primary>
</indexterm>
@@ -3227,7 +3227,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-init-zero" xreflabel="wal_init_zero">
- <term><varname>wal_init_zero</varname> (<type>boolean</type>)
+ <term><varname>wal_init_zero</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>wal_init_zero</varname> configuration parameter</primary>
</indexterm>
@@ -3246,7 +3246,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-recycle" xreflabel="wal_recycle">
- <term><varname>wal_recycle</varname> (<type>boolean</type>)
+ <term><varname>wal_recycle</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>wal_recycle</varname> configuration parameter</primary>
</indexterm>
@@ -3262,7 +3262,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-buffers" xreflabel="wal_buffers">
- <term><varname>wal_buffers</varname> (<type>integer</type>)
+ <term><varname>wal_buffers</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>wal_buffers</varname> configuration parameter</primary>
</indexterm>
@@ -3296,7 +3296,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-writer-delay" xreflabel="wal_writer_delay">
- <term><varname>wal_writer_delay</varname> (<type>integer</type>)
+ <term><varname>wal_writer_delay</varname> (<type>integer</type>) - default is 200ms
<indexterm>
<primary><varname>wal_writer_delay</varname> configuration parameter</primary>
</indexterm>
@@ -3323,7 +3323,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-writer-flush-after" xreflabel="wal_writer_flush_after">
- <term><varname>wal_writer_flush_after</varname> (<type>integer</type>)
+ <term><varname>wal_writer_flush_after</varname> (<type>integer</type>) - default is 1MB
<indexterm>
<primary><varname>wal_writer_flush_after</varname> configuration parameter</primary>
</indexterm>
@@ -3347,7 +3347,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-skip-threshold" xreflabel="wal_skip_threshold">
- <term><varname>wal_skip_threshold</varname> (<type>integer</type>)
+ <term><varname>wal_skip_threshold</varname> (<type>integer</type>) - default is 2MB
<indexterm>
<primary><varname>wal_skip_threshold</varname> configuration parameter</primary>
</indexterm>
@@ -3368,7 +3368,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-commit-delay" xreflabel="commit_delay">
- <term><varname>commit_delay</varname> (<type>integer</type>)
+ <term><varname>commit_delay</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>commit_delay</varname> configuration parameter</primary>
</indexterm>
@@ -3406,7 +3406,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-commit-siblings" xreflabel="commit_siblings">
- <term><varname>commit_siblings</varname> (<type>integer</type>)
+ <term><varname>commit_siblings</varname> (<type>integer</type>) - default is 5 transactions
<indexterm>
<primary><varname>commit_siblings</varname> configuration parameter</primary>
</indexterm>
@@ -3429,7 +3429,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-checkpoint-timeout" xreflabel="checkpoint_timeout">
- <term><varname>checkpoint_timeout</varname> (<type>integer</type>)
+ <term><varname>checkpoint_timeout</varname> (<type>integer</type>) - default is 5 minutes
<indexterm>
<primary><varname>checkpoint_timeout</varname> configuration parameter</primary>
</indexterm>
@@ -3449,7 +3449,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-checkpoint-completion-target" xreflabel="checkpoint_completion_target">
- <term><varname>checkpoint_completion_target</varname> (<type>floating point</type>)
+ <term><varname>checkpoint_completion_target</varname> (<type>floating point</type>) - default is 0.9
<indexterm>
<primary><varname>checkpoint_completion_target</varname> configuration parameter</primary>
</indexterm>
@@ -3471,7 +3471,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-checkpoint-flush-after" xreflabel="checkpoint_flush_after">
- <term><varname>checkpoint_flush_after</varname> (<type>integer</type>)
+ <term><varname>checkpoint_flush_after</varname> (<type>integer</type>) - default is 256kb
<indexterm>
<primary><varname>checkpoint_flush_after</varname> configuration parameter</primary>
</indexterm>
@@ -3503,7 +3503,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-checkpoint-warning" xreflabel="checkpoint_warning">
- <term><varname>checkpoint_warning</varname> (<type>integer</type>)
+ <term><varname>checkpoint_warning</varname> (<type>integer</type>) - default is 30 seconds
<indexterm>
<primary><varname>checkpoint_warning</varname> configuration parameter</primary>
</indexterm>
@@ -3526,7 +3526,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-max-wal-size" xreflabel="max_wal_size">
- <term><varname>max_wal_size</varname> (<type>integer</type>)
+ <term><varname>max_wal_size</varname> (<type>integer</type>) - default is 1GB
<indexterm>
<primary><varname>max_wal_size</varname> configuration parameter</primary>
</indexterm>
@@ -3549,7 +3549,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-min-wal-size" xreflabel="min_wal_size">
- <term><varname>min_wal_size</varname> (<type>integer</type>)
+ <term><varname>min_wal_size</varname> (<type>integer</type>) - default is 80MB
<indexterm>
<primary><varname>min_wal_size</varname> configuration parameter</primary>
</indexterm>
@@ -3610,7 +3610,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-archive-command" xreflabel="archive_command">
- <term><varname>archive_command</varname> (<type>string</type>)
+ <term><varname>archive_command</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>archive_command</varname> configuration parameter</primary>
</indexterm>
@@ -3650,7 +3650,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-archive-library" xreflabel="archive_library">
- <term><varname>archive_library</varname> (<type>string</type>)
+ <term><varname>archive_library</varname> (<type>string</type>) - default is an empty string
<indexterm>
<primary><varname>archive_library</varname> configuration parameter</primary>
</indexterm>
@@ -3730,7 +3730,7 @@ include_dir 'conf.d'
<variablelist>
<varlistentry id="guc-recovery-prefetch" xreflabel="recovery_prefetch">
- <term><varname>recovery_prefetch</varname> (<type>enum</type>)
+ <term><varname>recovery_prefetch</varname> (<type>enum</type>) - default is try
<indexterm>
<primary><varname>recovery_prefetch</varname> configuration parameter</primary>
</indexterm>
@@ -3756,7 +3756,7 @@ include_dir 'conf.d'
</varlistentry>
<varlistentry id="guc-wal-decode-buffer-size" xreflabel="wal_decode_buffer_size">
- <term><varname>wal_decode_buffer_size</varname> (<type>integer</type>)
+ <term><varname>wal_decode_buffer_size</varname> (<type>integer</type>) - default is 512kb
<indexterm>
<primary><varname>wal_decode_buffer_size</varname> configuration parameter</primary>
</indexterm>
@@ -4072,7 +4072,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
<variablelist>
<varlistentry id="guc-recovery-target-inclusive"
xreflabel="recovery_target_inclusive">
- <term><varname>recovery_target_inclusive</varname> (<type>boolean</type>)
+ <term><varname>recovery_target_inclusive</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>recovery_target_inclusive</varname> configuration parameter</primary>
</indexterm>
@@ -4094,7 +4094,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
<varlistentry id="guc-recovery-target-timeline"
xreflabel="recovery_target_timeline">
- <term><varname>recovery_target_timeline</varname> (<type>string</type>)
+ <term><varname>recovery_target_timeline</varname> (<type>string</type>) - default is latest
<indexterm>
<primary><varname>recovery_target_timeline</varname> configuration parameter</primary>
</indexterm>
@@ -4129,7 +4129,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
<varlistentry id="guc-recovery-target-action"
xreflabel="recovery_target_action">
- <term><varname>recovery_target_action</varname> (<type>enum</type>)
+ <term><varname>recovery_target_action</varname> (<type>enum</type>) - default is pause
<indexterm>
<primary><varname>recovery_target_action</varname> configuration parameter</primary>
</indexterm>
@@ -4198,7 +4198,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
<variablelist>
<varlistentry id="guc-summarize-wal" xreflabel="summarize_wal">
- <term><varname>summarize_wal</varname> (<type>boolean</type>)
+ <term><varname>summarize_wal</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>summarize_wal</varname> configuration parameter</primary>
</indexterm>
@@ -4222,7 +4222,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
</varlistentry>
<varlistentry id="guc-wal-summary-keep-time" xreflabel="wal_summary_keep_time">
- <term><varname>wal_summary_keep_time</varname> (<type>integer</type>)
+ <term><varname>wal_summary_keep_time</varname> (<type>integer</type>) - default is 10 days
<indexterm>
<primary><varname>wal_summary_keep_time</varname> configuration parameter</primary>
</indexterm>
@@ -4302,7 +4302,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
<variablelist>
<varlistentry id="guc-max-wal-senders" xreflabel="max_wal_senders">
- <term><varname>max_wal_senders</varname> (<type>integer</type>)
+ <term><varname>max_wal_senders</varname> (<type>integer</type>) - default is 10
<indexterm>
<primary><varname>max_wal_senders</varname> configuration parameter</primary>
</indexterm>
@@ -4332,7 +4332,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
</varlistentry>
<varlistentry id="guc-max-replication-slots" xreflabel="max_replication_slots">
- <term><varname>max_replication_slots</varname> (<type>integer</type>)
+ <term><varname>max_replication_slots</varname> (<type>integer</type>) - default is 10
<indexterm>
<primary><varname>max_replication_slots</varname> configuration parameter</primary>
<secondary>in a sending server</secondary>
@@ -4361,7 +4361,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
</varlistentry>
<varlistentry id="guc-wal-keep-size" xreflabel="wal_keep_size">
- <term><varname>wal_keep_size</varname> (<type>integer</type>)
+ <term><varname>wal_keep_size</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>wal_keep_size</varname> configuration parameter</primary>
</indexterm>
@@ -4398,7 +4398,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
</varlistentry>
<varlistentry id="guc-max-slot-wal-keep-size" xreflabel="max_slot_wal_keep_size">
- <term><varname>max_slot_wal_keep_size</varname> (<type>integer</type>)
+ <term><varname>max_slot_wal_keep_size</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>max_slot_wal_keep_size</varname> configuration parameter</primary>
</indexterm>
@@ -4424,7 +4424,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
</varlistentry>
<varlistentry id="guc-wal-sender-timeout" xreflabel="wal_sender_timeout">
- <term><varname>wal_sender_timeout</varname> (<type>integer</type>)
+ <term><varname>wal_sender_timeout</varname> (<type>integer</type>) - default is 60 seconds
<indexterm>
<primary><varname>wal_sender_timeout</varname> configuration parameter</primary>
</indexterm>
@@ -4451,7 +4451,7 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows
</varlistentry>
<varlistentry id="guc-track-commit-timestamp" xreflabel="track_commit_timestamp">
- <term><varname>track_commit_timestamp</varname> (<type>boolean</type>)
+ <term><varname>track_commit_timestamp</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>track_commit_timestamp</varname> configuration parameter</primary>
</indexterm>
@@ -4741,7 +4741,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-hot-standby" xreflabel="hot_standby">
- <term><varname>hot_standby</varname> (<type>boolean</type>)
+ <term><varname>hot_standby</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>hot_standby</varname> configuration parameter</primary>
</indexterm>
@@ -4758,7 +4758,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-max-standby-archive-delay" xreflabel="max_standby_archive_delay">
- <term><varname>max_standby_archive_delay</varname> (<type>integer</type>)
+ <term><varname>max_standby_archive_delay</varname> (<type>integer</type>) - default is 30 seconds
<indexterm>
<primary><varname>max_standby_archive_delay</varname> configuration parameter</primary>
</indexterm>
@@ -4790,7 +4790,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-max-standby-streaming-delay" xreflabel="max_standby_streaming_delay">
- <term><varname>max_standby_streaming_delay</varname> (<type>integer</type>)
+ <term><varname>max_standby_streaming_delay</varname> (<type>integer</type>) - default is 30 seconds
<indexterm>
<primary><varname>max_standby_streaming_delay</varname> configuration parameter</primary>
</indexterm>
@@ -4823,7 +4823,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-wal-receiver-create-temp-slot" xreflabel="wal_receiver_create_temp_slot">
- <term><varname>wal_receiver_create_temp_slot</varname> (<type>boolean</type>)
+ <term><varname>wal_receiver_create_temp_slot</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>wal_receiver_create_temp_slot</varname> configuration parameter</primary>
</indexterm>
@@ -4843,7 +4843,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-wal-receiver-status-interval" xreflabel="wal_receiver_status_interval">
- <term><varname>wal_receiver_status_interval</varname> (<type>integer</type>)
+ <term><varname>wal_receiver_status_interval</varname> (<type>integer</type>) - default is 10 seconds
<indexterm>
<primary><varname>wal_receiver_status_interval</varname> configuration parameter</primary>
</indexterm>
@@ -4875,7 +4875,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-hot-standby-feedback" xreflabel="hot_standby_feedback">
- <term><varname>hot_standby_feedback</varname> (<type>boolean</type>)
+ <term><varname>hot_standby_feedback</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>hot_standby_feedback</varname> configuration parameter</primary>
</indexterm>
@@ -4901,7 +4901,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-wal-receiver-timeout" xreflabel="wal_receiver_timeout">
- <term><varname>wal_receiver_timeout</varname> (<type>integer</type>)
+ <term><varname>wal_receiver_timeout</varname> (<type>integer</type>) - default is 60 seconds
<indexterm>
<primary><varname>wal_receiver_timeout</varname> configuration parameter</primary>
</indexterm>
@@ -4923,7 +4923,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-wal-retrieve-retry-interval" xreflabel="wal_retrieve_retry_interval">
- <term><varname>wal_retrieve_retry_interval</varname> (<type>integer</type>)
+ <term><varname>wal_retrieve_retry_interval</varname> (<type>integer</type>) - default is 5 seconds
<indexterm>
<primary><varname>wal_retrieve_retry_interval</varname> configuration parameter</primary>
</indexterm>
@@ -4960,7 +4960,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-recovery-min-apply-delay" xreflabel="recovery_min_apply_delay">
- <term><varname>recovery_min_apply_delay</varname> (<type>integer</type>)
+ <term><varname>recovery_min_apply_delay</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>recovery_min_apply_delay</varname> configuration parameter</primary>
</indexterm>
@@ -5031,7 +5031,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-sync-replication-slots" xreflabel="sync_replication_slots">
- <term><varname>sync_replication_slots</varname> (<type>boolean</type>)
+ <term><varname>sync_replication_slots</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>sync_replication_slots</varname> configuration parameter</primary>
</indexterm>
@@ -5093,7 +5093,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-max-logical-replication-workers" xreflabel="max_logical_replication_workers">
- <term><varname>max_logical_replication_workers</varname> (<type>integer</type>)
+ <term><varname>max_logical_replication_workers</varname> (<type>integer</type>) - default is 4
<indexterm>
<primary><varname>max_logical_replication_workers</varname> configuration parameter</primary>
</indexterm>
@@ -5116,7 +5116,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-max-sync-workers-per-subscription" xreflabel="max_sync_workers_per_subscription">
- <term><varname>max_sync_workers_per_subscription</varname> (<type>integer</type>)
+ <term><varname>max_sync_workers_per_subscription</varname> (<type>integer</type>) - default is 2
<indexterm>
<primary><varname>max_sync_workers_per_subscription</varname> configuration parameter</primary>
</indexterm>
@@ -5143,7 +5143,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-max-parallel-apply-workers-per-subscription" xreflabel="max_parallel_apply_workers_per_subscription">
- <term><varname>max_parallel_apply_workers_per_subscription</varname> (<type>integer</type>)
+ <term><varname>max_parallel_apply_workers_per_subscription</varname> (<type>integer</type>) - default is 2
<indexterm>
<primary><varname>max_parallel_apply_workers_per_subscription</varname> configuration parameter</primary>
</indexterm>
@@ -5198,7 +5198,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
<variablelist>
<varlistentry id="guc-enable-async-append" xreflabel="enable_async_append">
- <term><varname>enable_async_append</varname> (<type>boolean</type>)
+ <term><varname>enable_async_append</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_async_append</varname> configuration parameter</primary>
</indexterm>
@@ -5212,7 +5212,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-bitmapscan" xreflabel="enable_bitmapscan">
- <term><varname>enable_bitmapscan</varname> (<type>boolean</type>)
+ <term><varname>enable_bitmapscan</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary>bitmap scan</primary>
</indexterm>
@@ -5243,7 +5243,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-gathermerge" xreflabel="enable_gathermerge">
- <term><varname>enable_gathermerge</varname> (<type>boolean</type>)
+ <term><varname>enable_gathermerge</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_gathermerge</varname> configuration parameter</primary>
</indexterm>
@@ -5257,7 +5257,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-groupby-reordering" xreflabel="enable_group_by_reordering">
- <term><varname>enable_group_by_reordering</varname> (<type>boolean</type>)
+ <term><varname>enable_group_by_reordering</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_group_by_reordering</varname> configuration parameter</primary>
</indexterm>
@@ -5276,7 +5276,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-hashagg" xreflabel="enable_hashagg">
- <term><varname>enable_hashagg</varname> (<type>boolean</type>)
+ <term><varname>enable_hashagg</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_hashagg</varname> configuration parameter</primary>
</indexterm>
@@ -5290,7 +5290,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-hashjoin" xreflabel="enable_hashjoin">
- <term><varname>enable_hashjoin</varname> (<type>boolean</type>)
+ <term><varname>enable_hashjoin</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_hashjoin</varname> configuration parameter</primary>
</indexterm>
@@ -5304,7 +5304,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-incremental-sort" xreflabel="enable_incremental_sort">
- <term><varname>enable_incremental_sort</varname> (<type>boolean</type>)
+ <term><varname>enable_incremental_sort</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_incremental_sort</varname> configuration parameter</primary>
</indexterm>
@@ -5318,7 +5318,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-indexscan" xreflabel="enable_indexscan">
- <term><varname>enable_indexscan</varname> (<type>boolean</type>)
+ <term><varname>enable_indexscan</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary>index scan</primary>
</indexterm>
@@ -5336,7 +5336,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-indexonlyscan" xreflabel="enable_indexonlyscan">
- <term><varname>enable_indexonlyscan</varname> (<type>boolean</type>)
+ <term><varname>enable_indexonlyscan</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_indexonlyscan</varname> configuration parameter</primary>
</indexterm>
@@ -5353,7 +5353,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-material" xreflabel="enable_material">
- <term><varname>enable_material</varname> (<type>boolean</type>)
+ <term><varname>enable_material</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_material</varname> configuration parameter</primary>
</indexterm>
@@ -5370,7 +5370,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-memoize" xreflabel="enable_memoize">
- <term><varname>enable_memoize</varname> (<type>boolean</type>)
+ <term><varname>enable_memoize</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_memoize</varname> configuration parameter</primary>
</indexterm>
@@ -5389,7 +5389,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-mergejoin" xreflabel="enable_mergejoin">
- <term><varname>enable_mergejoin</varname> (<type>boolean</type>)
+ <term><varname>enable_mergejoin</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_mergejoin</varname> configuration parameter</primary>
</indexterm>
@@ -5403,7 +5403,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-nestloop" xreflabel="enable_nestloop">
- <term><varname>enable_nestloop</varname> (<type>boolean</type>)
+ <term><varname>enable_nestloop</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_nestloop</varname> configuration parameter</primary>
</indexterm>
@@ -5420,7 +5420,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-parallel-append" xreflabel="enable_parallel_append">
- <term><varname>enable_parallel_append</varname> (<type>boolean</type>)
+ <term><varname>enable_parallel_append</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_parallel_append</varname> configuration parameter</primary>
</indexterm>
@@ -5434,7 +5434,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-parallel-hash" xreflabel="enable_parallel_hash">
- <term><varname>enable_parallel_hash</varname> (<type>boolean</type>)
+ <term><varname>enable_parallel_hash</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_parallel_hash</varname> configuration parameter</primary>
</indexterm>
@@ -5449,7 +5449,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-partition-pruning" xreflabel="enable_partition_pruning">
- <term><varname>enable_partition_pruning</varname> (<type>boolean</type>)
+ <term><varname>enable_partition_pruning</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_partition_pruning</varname> configuration parameter</primary>
</indexterm>
@@ -5467,7 +5467,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-partitionwise-join" xreflabel="enable_partitionwise_join">
- <term><varname>enable_partitionwise_join</varname> (<type>boolean</type>)
+ <term><varname>enable_partitionwise_join</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_partitionwise_join</varname> configuration parameter</primary>
</indexterm>
@@ -5491,7 +5491,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-partitionwise-aggregate" xreflabel="enable_partitionwise_aggregate">
- <term><varname>enable_partitionwise_aggregate</varname> (<type>boolean</type>)
+ <term><varname>enable_partitionwise_aggregate</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_partitionwise_aggregate</varname> configuration parameter</primary>
</indexterm>
@@ -5516,7 +5516,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-presorted-aggregate" xreflabel="enable_presorted_aggregate">
- <term><varname>enable_presorted_aggregate</varname> (<type>boolean</type>)
+ <term><varname>enable_presorted_aggregate</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_presorted_aggregate</varname> configuration parameter</primary>
</indexterm>
@@ -5539,7 +5539,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-seqscan" xreflabel="enable_seqscan">
- <term><varname>enable_seqscan</varname> (<type>boolean</type>)
+ <term><varname>enable_seqscan</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary>sequential scan</primary>
</indexterm>
@@ -5559,7 +5559,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-sort" xreflabel="enable_sort">
- <term><varname>enable_sort</varname> (<type>boolean</type>)
+ <term><varname>enable_sort</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_sort</varname> configuration parameter</primary>
</indexterm>
@@ -5576,7 +5576,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-enable-tidscan" xreflabel="enable_tidscan">
- <term><varname>enable_tidscan</varname> (<type>boolean</type>)
+ <term><varname>enable_tidscan</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>enable_tidscan</varname> configuration parameter</primary>
</indexterm>
@@ -5619,7 +5619,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
<variablelist>
<varlistentry id="guc-seq-page-cost" xreflabel="seq_page_cost">
- <term><varname>seq_page_cost</varname> (<type>floating point</type>)
+ <term><varname>seq_page_cost</varname> (<type>floating point</type>) - default is 1.0
<indexterm>
<primary><varname>seq_page_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5636,7 +5636,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-random-page-cost" xreflabel="random_page_cost">
- <term><varname>random_page_cost</varname> (<type>floating point</type>)
+ <term><varname>random_page_cost</varname> (<type>floating point</type>) - default is 4.0
<indexterm>
<primary><varname>random_page_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5696,7 +5696,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-cpu-tuple-cost" xreflabel="cpu_tuple_cost">
- <term><varname>cpu_tuple_cost</varname> (<type>floating point</type>)
+ <term><varname>cpu_tuple_cost</varname> (<type>floating point</type>) - default is 0.01
<indexterm>
<primary><varname>cpu_tuple_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5711,7 +5711,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-cpu-index-tuple-cost" xreflabel="cpu_index_tuple_cost">
- <term><varname>cpu_index_tuple_cost</varname> (<type>floating point</type>)
+ <term><varname>cpu_index_tuple_cost</varname> (<type>floating point</type>) - default is 0.005
<indexterm>
<primary><varname>cpu_index_tuple_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5726,7 +5726,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-cpu-operator-cost" xreflabel="cpu_operator_cost">
- <term><varname>cpu_operator_cost</varname> (<type>floating point</type>)
+ <term><varname>cpu_operator_cost</varname> (<type>floating point</type>) - default is 0.0025
<indexterm>
<primary><varname>cpu_operator_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5741,7 +5741,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-parallel-setup-cost" xreflabel="parallel_setup_cost">
- <term><varname>parallel_setup_cost</varname> (<type>floating point</type>)
+ <term><varname>parallel_setup_cost</varname> (<type>floating point</type>) - default is 1000
<indexterm>
<primary><varname>parallel_setup_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5756,7 +5756,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-parallel-tuple-cost" xreflabel="parallel_tuple_cost">
- <term><varname>parallel_tuple_cost</varname> (<type>floating point</type>)
+ <term><varname>parallel_tuple_cost</varname> (<type>floating point</type>) - default is 0.1
<indexterm>
<primary><varname>parallel_tuple_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5771,7 +5771,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-min-parallel-table-scan-size" xreflabel="min_parallel_table_scan_size">
- <term><varname>min_parallel_table_scan_size</varname> (<type>integer</type>)
+ <term><varname>min_parallel_table_scan_size</varname> (<type>integer</type>) - default is 8MB
<indexterm>
<primary><varname>min_parallel_table_scan_size</varname> configuration parameter</primary>
</indexterm>
@@ -5791,7 +5791,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-min-parallel-index-scan-size" xreflabel="min_parallel_index_scan_size">
- <term><varname>min_parallel_index_scan_size</varname> (<type>integer</type>)
+ <term><varname>min_parallel_index_scan_size</varname> (<type>integer</type>) - default is 512kb
<indexterm>
<primary><varname>min_parallel_index_scan_size</varname> configuration parameter</primary>
</indexterm>
@@ -5813,7 +5813,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-effective-cache-size" xreflabel="effective_cache_size">
- <term><varname>effective_cache_size</varname> (<type>integer</type>)
+ <term><varname>effective_cache_size</varname> (<type>integer</type>) - default is 4MB
<indexterm>
<primary><varname>effective_cache_size</varname> configuration parameter</primary>
</indexterm>
@@ -5847,7 +5847,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-jit-above-cost" xreflabel="jit_above_cost">
- <term><varname>jit_above_cost</varname> (<type>floating point</type>)
+ <term><varname>jit_above_cost</varname> (<type>floating point</type>) - default is 100000
<indexterm>
<primary><varname>jit_above_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5865,7 +5865,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-jit-inline-above-cost" xreflabel="jit_inline_above_cost">
- <term><varname>jit_inline_above_cost</varname> (<type>floating point</type>)
+ <term><varname>jit_inline_above_cost</varname> (<type>floating point</type>) - default is 500000
<indexterm>
<primary><varname>jit_inline_above_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5883,7 +5883,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-jit-optimize-above-cost" xreflabel="jit_optimize_above_cost">
- <term><varname>jit_optimize_above_cost</varname> (<type>floating point</type>)
+ <term><varname>jit_optimize_above_cost</varname> (<type>floating point</type>) - default is 500000
<indexterm>
<primary><varname>jit_optimize_above_cost</varname> configuration parameter</primary>
</indexterm>
@@ -5920,7 +5920,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
<variablelist>
<varlistentry id="guc-geqo" xreflabel="geqo">
- <term><varname>geqo</varname> (<type>boolean</type>)
+ <term><varname>geqo</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary>genetic query optimization</primary>
</indexterm>
@@ -5943,7 +5943,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-geqo-threshold" xreflabel="geqo_threshold">
- <term><varname>geqo_threshold</varname> (<type>integer</type>)
+ <term><varname>geqo_threshold</varname> (<type>integer</type>) - default is 12
<indexterm>
<primary><varname>geqo_threshold</varname> configuration parameter</primary>
</indexterm>
@@ -5964,7 +5964,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-geqo-effort" xreflabel="geqo_effort">
- <term><varname>geqo_effort</varname> (<type>integer</type>)
+ <term><varname>geqo_effort</varname> (<type>integer</type>) - default is 5
<indexterm>
<primary><varname>geqo_effort</varname> configuration parameter</primary>
</indexterm>
@@ -5990,7 +5990,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-geqo-pool-size" xreflabel="geqo_pool_size">
- <term><varname>geqo_pool_size</varname> (<type>integer</type>)
+ <term><varname>geqo_pool_size</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>geqo_pool_size</varname> configuration parameter</primary>
</indexterm>
@@ -6008,7 +6008,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-geqo-generations" xreflabel="geqo_generations">
- <term><varname>geqo_generations</varname> (<type>integer</type>)
+ <term><varname>geqo_generations</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>geqo_generations</varname> configuration parameter</primary>
</indexterm>
@@ -6026,7 +6026,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-geqo-selection-bias" xreflabel="geqo_selection_bias">
- <term><varname>geqo_selection_bias</varname> (<type>floating point</type>)
+ <term><varname>geqo_selection_bias</varname> (<type>floating point</type>) - default is 2.00
<indexterm>
<primary><varname>geqo_selection_bias</varname> configuration parameter</primary>
</indexterm>
@@ -6041,7 +6041,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-geqo-seed" xreflabel="geqo_seed">
- <term><varname>geqo_seed</varname> (<type>floating point</type>)
+ <term><varname>geqo_seed</varname> (<type>floating point</type>) - default is 1
<indexterm>
<primary><varname>geqo_seed</varname> configuration parameter</primary>
</indexterm>
@@ -6065,7 +6065,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
<variablelist>
<varlistentry id="guc-default-statistics-target" xreflabel="default_statistics_target">
- <term><varname>default_statistics_target</varname> (<type>integer</type>)
+ <term><varname>default_statistics_target</varname> (<type>integer</type>) - default is 100
<indexterm>
<primary><varname>default_statistics_target</varname> configuration parameter</primary>
</indexterm>
@@ -6084,7 +6084,7 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class="
</varlistentry>
<varlistentry id="guc-constraint-exclusion" xreflabel="constraint_exclusion">
- <term><varname>constraint_exclusion</varname> (<type>enum</type>)
+ <term><varname>constraint_exclusion</varname> (<type>enum</type>) - default is partition
<indexterm>
<primary>constraint exclusion</primary>
</indexterm>
@@ -6145,7 +6145,7 @@ SELECT * FROM parent WHERE key = 2400;
</varlistentry>
<varlistentry id="guc-cursor-tuple-fraction" xreflabel="cursor_tuple_fraction">
- <term><varname>cursor_tuple_fraction</varname> (<type>floating point</type>)
+ <term><varname>cursor_tuple_fraction</varname> (<type>floating point</type>) - default is 0.1
<indexterm>
<primary><varname>cursor_tuple_fraction</varname> configuration parameter</primary>
</indexterm>
@@ -6166,7 +6166,7 @@ SELECT * FROM parent WHERE key = 2400;
</varlistentry>
<varlistentry id="guc-from-collapse-limit" xreflabel="from_collapse_limit">
- <term><varname>from_collapse_limit</varname> (<type>integer</type>)
+ <term><varname>from_collapse_limit</varname> (<type>integer</type>) - default is 8
<indexterm>
<primary><varname>from_collapse_limit</varname> configuration parameter</primary>
</indexterm>
@@ -6189,7 +6189,7 @@ SELECT * FROM parent WHERE key = 2400;
</varlistentry>
<varlistentry id="guc-jit" xreflabel="jit">
- <term><varname>jit</varname> (<type>boolean</type>)
+ <term><varname>jit</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>jit</varname> configuration parameter</primary>
</indexterm>
@@ -6205,7 +6205,7 @@ SELECT * FROM parent WHERE key = 2400;
</varlistentry>
<varlistentry id="guc-join-collapse-limit" xreflabel="join_collapse_limit">
- <term><varname>join_collapse_limit</varname> (<type>integer</type>)
+ <term><varname>join_collapse_limit</varname> (<type>integer</type>) - default is the same as from_collapse_limit
<indexterm>
<primary><varname>join_collapse_limit</varname> configuration parameter</primary>
</indexterm>
@@ -6241,7 +6241,7 @@ SELECT * FROM parent WHERE key = 2400;
</varlistentry>
<varlistentry id="guc-plan-cache-mode" xreflabel="plan_cache_mode">
- <term><varname>plan_cache_mode</varname> (<type>enum</type>)
+ <term><varname>plan_cache_mode</varname> (<type>enum</type>) - default is auto
<indexterm>
<primary><varname>plan_cache_mode</varname> configuration parameter</primary>
</indexterm>
@@ -6269,7 +6269,7 @@ SELECT * FROM parent WHERE key = 2400;
</varlistentry>
<varlistentry id="guc-recursive-worktable-factor" xreflabel="recursive_worktable_factor">
- <term><varname>recursive_worktable_factor</varname> (<type>floating point</type>)
+ <term><varname>recursive_worktable_factor</varname> (<type>floating point</type>) - default is 10.0
<indexterm>
<primary><varname>recursive_worktable_factor</varname> configuration parameter</primary>
</indexterm>
@@ -6454,7 +6454,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-directory" xreflabel="log_directory">
- <term><varname>log_directory</varname> (<type>string</type>)
+ <term><varname>log_directory</varname> (<type>string</type>) - default is log
<indexterm>
<primary><varname>log_directory</varname> configuration parameter</primary>
</indexterm>
@@ -6473,7 +6473,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-filename" xreflabel="log_filename">
- <term><varname>log_filename</varname> (<type>string</type>)
+ <term><varname>log_filename</varname> (<type>string</type>) - default is postgresql-%Y-%m-%d_%H%M%S.log
<indexterm>
<primary><varname>log_filename</varname> configuration parameter</primary>
</indexterm>
@@ -6527,7 +6527,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-file-mode" xreflabel="log_file_mode">
- <term><varname>log_file_mode</varname> (<type>integer</type>)
+ <term><varname>log_file_mode</varname> (<type>integer</type>) - default is 0600
<indexterm>
<primary><varname>log_file_mode</varname> configuration parameter</primary>
</indexterm>
@@ -6561,7 +6561,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-rotation-age" xreflabel="log_rotation_age">
- <term><varname>log_rotation_age</varname> (<type>integer</type>)
+ <term><varname>log_rotation_age</varname> (<type>integer</type>) - default is 24hours
<indexterm>
<primary><varname>log_rotation_age</varname> configuration parameter</primary>
</indexterm>
@@ -6581,7 +6581,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-rotation-size" xreflabel="log_rotation_size">
- <term><varname>log_rotation_size</varname> (<type>integer</type>)
+ <term><varname>log_rotation_size</varname> (<type>integer</type>) - default is 10MB
<indexterm>
<primary><varname>log_rotation_size</varname> configuration parameter</primary>
</indexterm>
@@ -6645,7 +6645,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-syslog-facility" xreflabel="syslog_facility">
- <term><varname>syslog_facility</varname> (<type>enum</type>)
+ <term><varname>syslog_facility</varname> (<type>enum</type>) - default is LOCAL0
<indexterm>
<primary><varname>syslog_facility</varname> configuration parameter</primary>
</indexterm>
@@ -6668,7 +6668,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-syslog-ident" xreflabel="syslog_ident">
- <term><varname>syslog_ident</varname> (<type>string</type>)
+ <term><varname>syslog_ident</varname> (<type>string</type>) - default is postgres
<indexterm>
<primary><varname>syslog_ident</varname> configuration parameter</primary>
</indexterm>
@@ -6687,7 +6687,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-syslog-sequence-numbers" xreflabel="syslog_sequence_numbers">
- <term><varname>syslog_sequence_numbers</varname> (<type>boolean</type>)
+ <term><varname>syslog_sequence_numbers</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>syslog_sequence_numbers</varname> configuration parameter</primary>
</indexterm>
@@ -6715,7 +6715,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-syslog-split-messages" xreflabel="syslog_split_messages">
- <term><varname>syslog_split_messages</varname> (<type>boolean</type>)
+ <term><varname>syslog_split_messages</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>syslog_split_messages</varname> configuration parameter</primary>
</indexterm>
@@ -6748,7 +6748,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-event-source" xreflabel="event_source">
- <term><varname>event_source</varname> (<type>string</type>)
+ <term><varname>event_source</varname> (<type>string</type>) - default is PostgreSQL
<indexterm>
<primary><varname>event_source</varname> configuration parameter</primary>
</indexterm>
@@ -6773,7 +6773,7 @@ local0.* /var/log/postgresql
<variablelist>
<varlistentry id="guc-log-min-messages" xreflabel="log_min_messages">
- <term><varname>log_min_messages</varname> (<type>enum</type>)
+ <term><varname>log_min_messages</varname> (<type>enum</type>) - default is WARNING
<indexterm>
<primary><varname>log_min_messages</varname> configuration parameter</primary>
</indexterm>
@@ -6798,7 +6798,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-min-error-statement" xreflabel="log_min_error_statement">
- <term><varname>log_min_error_statement</varname> (<type>enum</type>)
+ <term><varname>log_min_error_statement</varname> (<type>enum</type>) - default is ERROR
<indexterm>
<primary><varname>log_min_error_statement</varname> configuration parameter</primary>
</indexterm>
@@ -6829,7 +6829,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-min-duration-statement" xreflabel="log_min_duration_statement">
- <term><varname>log_min_duration_statement</varname> (<type>integer</type>)
+ <term><varname>log_min_duration_statement</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>log_min_duration_statement</varname> configuration parameter</primary>
</indexterm>
@@ -6879,7 +6879,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-min-duration-sample" xreflabel="log_min_duration_sample">
- <term><varname>log_min_duration_sample</varname> (<type>integer</type>)
+ <term><varname>log_min_duration_sample</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>log_min_duration_sample</varname> configuration parameter</primary>
</indexterm>
@@ -6920,7 +6920,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-statement-sample-rate" xreflabel="log_statement_sample_rate">
- <term><varname>log_statement_sample_rate</varname> (<type>floating point</type>)
+ <term><varname>log_statement_sample_rate</varname> (<type>floating point</type>) - default is 1.0
<indexterm>
<primary><varname>log_statement_sample_rate</varname> configuration parameter</primary>
</indexterm>
@@ -6945,7 +6945,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-transaction-sample-rate" xreflabel="log_transaction_sample_rate">
- <term><varname>log_transaction_sample_rate</varname> (<type>floating point</type>)
+ <term><varname>log_transaction_sample_rate</varname> (<type>floating point</type>) - default is 0
<indexterm>
<primary><varname>log_transaction_sample_rate</varname> configuration parameter</primary>
</indexterm>
@@ -6976,7 +6976,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-startup-progress-interval" xreflabel="log_startup_progress_interval">
- <term><varname>log_startup_progress_interval</varname> (<type>integer</type>)
+ <term><varname>log_startup_progress_interval</varname> (<type>integer</type>) - default is 10 seconds
<indexterm>
<primary><varname>log_startup_progress_interval</varname> configuration parameter</primary>
</indexterm>
@@ -7144,7 +7144,7 @@ local0.* /var/log/postgresql
<primary><varname>debug_print_rewritten</varname> configuration parameter</primary>
</indexterm>
</term>
- <term><varname>debug_print_plan</varname> (<type>boolean</type>)
+ <term><varname>debug_print_plan</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>debug_print_plan</varname> configuration parameter</primary>
</indexterm>
@@ -7165,7 +7165,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-debug-pretty-print">
- <term><varname>debug_pretty_print</varname> (<type>boolean</type>)
+ <term><varname>debug_pretty_print</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>debug_pretty_print</varname> configuration parameter</primary>
</indexterm>
@@ -7183,7 +7183,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-autovacuum-min-duration" xreflabel="log_autovacuum_min_duration">
- <term><varname>log_autovacuum_min_duration</varname> (<type>integer</type>)
+ <term><varname>log_autovacuum_min_duration</varname> (<type>integer</type>) - default is 10 minutes
<indexterm>
<primary><varname>log_autovacuum_min_duration</varname></primary>
<secondary>configuration parameter</secondary>
@@ -7210,7 +7210,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-checkpoints" xreflabel="log_checkpoints">
- <term><varname>log_checkpoints</varname> (<type>boolean</type>)
+ <term><varname>log_checkpoints</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>log_checkpoints</varname> configuration parameter</primary>
</indexterm>
@@ -7227,7 +7227,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-connections" xreflabel="log_connections">
- <term><varname>log_connections</varname> (<type>boolean</type>)
+ <term><varname>log_connections</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_connections</varname> configuration parameter</primary>
</indexterm>
@@ -7255,7 +7255,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-disconnections" xreflabel="log_disconnections">
- <term><varname>log_disconnections</varname> (<type>boolean</type>)
+ <term><varname>log_disconnections</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_disconnections</varname> configuration parameter</primary>
</indexterm>
@@ -7275,7 +7275,7 @@ local0.* /var/log/postgresql
<varlistentry id="guc-log-duration" xreflabel="log_duration">
- <term><varname>log_duration</varname> (<type>boolean</type>)
+ <term><varname>log_duration</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_duration</varname> configuration parameter</primary>
</indexterm>
@@ -7310,7 +7310,7 @@ local0.* /var/log/postgresql
</varlistentry>
<varlistentry id="guc-log-error-verbosity" xreflabel="log_error_verbosity">
- <term><varname>log_error_verbosity</varname> (<type>enum</type>)
+ <term><varname>log_error_verbosity</varname> (<type>enum</type>) - default is DEFAULT
<indexterm>
<primary><varname>log_error_verbosity</varname> configuration parameter</primary>
</indexterm>
@@ -7573,7 +7573,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
</varlistentry>
<varlistentry id="guc-log-lock-waits" xreflabel="log_lock_waits">
- <term><varname>log_lock_waits</varname> (<type>boolean</type>)
+ <term><varname>log_lock_waits</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_lock_waits</varname> configuration parameter</primary>
</indexterm>
@@ -7591,7 +7591,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
</varlistentry>
<varlistentry id="guc-log-recovery-conflict-waits" xreflabel="log_recovery_conflict_waits">
- <term><varname>log_recovery_conflict_waits</varname> (<type>boolean</type>)
+ <term><varname>log_recovery_conflict_waits</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_recovery_conflict_waits</varname> configuration parameter</primary>
</indexterm>
@@ -7613,7 +7613,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
</varlistentry>
<varlistentry id="guc-log-parameter-max-length" xreflabel="log_parameter_max_length">
- <term><varname>log_parameter_max_length</varname> (<type>integer</type>)
+ <term><varname>log_parameter_max_length</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>log_parameter_max_length</varname> configuration parameter</primary>
</indexterm>
@@ -7641,7 +7641,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
</varlistentry>
<varlistentry id="guc-log-parameter-max-length-on-error" xreflabel="log_parameter_max_length_on_error">
- <term><varname>log_parameter_max_length_on_error</varname> (<type>integer</type>)
+ <term><varname>log_parameter_max_length_on_error</varname> (<type>integer</type>) - default is 0
<indexterm>
<primary><varname>log_parameter_max_length_on_error</varname> configuration parameter</primary>
</indexterm>
@@ -7669,7 +7669,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
</varlistentry>
<varlistentry id="guc-log-statement" xreflabel="log_statement">
- <term><varname>log_statement</varname> (<type>enum</type>)
+ <term><varname>log_statement</varname> (<type>enum</type>) - default is none
<indexterm>
<primary><varname>log_statement</varname> configuration parameter</primary>
</indexterm>
@@ -7719,7 +7719,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
</varlistentry>
<varlistentry id="guc-log-replication-commands" xreflabel="log_replication_commands">
- <term><varname>log_replication_commands</varname> (<type>boolean</type>)
+ <term><varname>log_replication_commands</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_replication_commands</varname> configuration parameter</primary>
</indexterm>
@@ -7737,7 +7737,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
</varlistentry>
<varlistentry id="guc-log-temp-files" xreflabel="log_temp_files">
- <term><varname>log_temp_files</varname> (<type>integer</type>)
+ <term><varname>log_temp_files</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>log_temp_files</varname> configuration parameter</primary>
</indexterm>
@@ -7761,7 +7761,7 @@ log_line_prefix = '%m [%p] %q%u@%d/%a '
</varlistentry>
<varlistentry id="guc-log-timezone" xreflabel="log_timezone">
- <term><varname>log_timezone</varname> (<type>string</type>)
+ <term><varname>log_timezone</varname> (<type>string</type>) - default is GMT
<indexterm>
<primary><varname>log_timezone</varname> configuration parameter</primary>
</indexterm>
@@ -8152,7 +8152,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-update-process-title" xreflabel="update_process_title">
- <term><varname>update_process_title</varname> (<type>boolean</type>)
+ <term><varname>update_process_title</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>update_process_title</varname> configuration parameter</primary>
</indexterm>
@@ -8190,7 +8190,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
<variablelist>
<varlistentry id="guc-track-activities" xreflabel="track_activities">
- <term><varname>track_activities</varname> (<type>boolean</type>)
+ <term><varname>track_activities</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>track_activities</varname> configuration parameter</primary>
</indexterm>
@@ -8212,7 +8212,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-track-activity-query-size" xreflabel="track_activity_query_size">
- <term><varname>track_activity_query_size</varname> (<type>integer</type>)
+ <term><varname>track_activity_query_size</varname> (<type>integer</type>) - default is 1024 bytes
<indexterm>
<primary><varname>track_activity_query_size</varname> configuration parameter</primary>
</indexterm>
@@ -8230,7 +8230,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-track-counts" xreflabel="track_counts">
- <term><varname>track_counts</varname> (<type>boolean</type>)
+ <term><varname>track_counts</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>track_counts</varname> configuration parameter</primary>
</indexterm>
@@ -8247,7 +8247,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-track-io-timing" xreflabel="track_io_timing">
- <term><varname>track_io_timing</varname> (<type>boolean</type>)
+ <term><varname>track_io_timing</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>track_io_timing</varname> configuration parameter</primary>
</indexterm>
@@ -8279,7 +8279,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-track-wal-io-timing" xreflabel="track_wal_io_timing">
- <term><varname>track_wal_io_timing</varname> (<type>boolean</type>)
+ <term><varname>track_wal_io_timing</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>track_wal_io_timing</varname> configuration parameter</primary>
</indexterm>
@@ -8301,7 +8301,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-track-functions" xreflabel="track_functions">
- <term><varname>track_functions</varname> (<type>enum</type>)
+ <term><varname>track_functions</varname> (<type>enum</type>) - default is none
<indexterm>
<primary><varname>track_functions</varname> configuration parameter</primary>
</indexterm>
@@ -8328,7 +8328,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-stats-fetch-consistency" xreflabel="stats_fetch_consistency">
- <term><varname>stats_fetch_consistency</varname> (<type>enum</type>)
+ <term><varname>stats_fetch_consistency</varname> (<type>enum</type>) - default is cache
<indexterm>
<primary><varname>stats_fetch_consistency</varname> configuration parameter</primary>
</indexterm>
@@ -8370,7 +8370,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
<variablelist>
<varlistentry id="guc-compute-query-id" xreflabel="compute_query_id">
- <term><varname>compute_query_id</varname> (<type>enum</type>)
+ <term><varname>compute_query_id</varname> (<type>enum</type>) - default is auto
<indexterm>
<primary><varname>compute_query_id</varname> configuration parameter</primary>
</indexterm>
@@ -8407,22 +8407,22 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-log-statement-stats">
- <term><varname>log_statement_stats</varname> (<type>boolean</type>)
+ <term><varname>log_statement_stats</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_statement_stats</varname> configuration parameter</primary>
</indexterm>
</term>
- <term><varname>log_parser_stats</varname> (<type>boolean</type>)
+ <term><varname>log_parser_stats</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_parser_stats</varname> configuration parameter</primary>
</indexterm>
</term>
- <term><varname>log_planner_stats</varname> (<type>boolean</type>)
+ <term><varname>log_planner_stats</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_planner_stats</varname> configuration parameter</primary>
</indexterm>
</term>
- <term><varname>log_executor_stats</varname> (<type>boolean</type>)
+ <term><varname>log_executor_stats</varname> (<type>boolean</type>) - default is off
<indexterm>
<primary><varname>log_executor_stats</varname> configuration parameter</primary>
</indexterm>
@@ -8474,7 +8474,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
<variablelist>
<varlistentry id="guc-autovacuum" xreflabel="autovacuum">
- <term><varname>autovacuum</varname> (<type>boolean</type>)
+ <term><varname>autovacuum</varname> (<type>boolean</type>) - default is on
<indexterm>
<primary><varname>autovacuum</varname> configuration parameter</primary>
</indexterm>
@@ -8519,7 +8519,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-max-workers" xreflabel="autovacuum_max_workers">
- <term><varname>autovacuum_max_workers</varname> (<type>integer</type>)
+ <term><varname>autovacuum_max_workers</varname> (<type>integer</type>) - default is 3
<indexterm>
<primary><varname>autovacuum_max_workers</varname> configuration parameter</primary>
</indexterm>
@@ -8541,7 +8541,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-naptime" xreflabel="autovacuum_naptime">
- <term><varname>autovacuum_naptime</varname> (<type>integer</type>)
+ <term><varname>autovacuum_naptime</varname> (<type>integer</type>) - default is 1 minute
<indexterm>
<primary><varname>autovacuum_naptime</varname> configuration parameter</primary>
</indexterm>
@@ -8561,7 +8561,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-vacuum-threshold" xreflabel="autovacuum_vacuum_threshold">
- <term><varname>autovacuum_vacuum_threshold</varname> (<type>integer</type>)
+ <term><varname>autovacuum_vacuum_threshold</varname> (<type>integer</type>) - default is 50 tuples
<indexterm>
<primary><varname>autovacuum_vacuum_threshold</varname></primary>
<secondary>configuration parameter</secondary>
@@ -8581,7 +8581,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-vacuum-insert-threshold" xreflabel="autovacuum_vacuum_insert_threshold">
- <term><varname>autovacuum_vacuum_insert_threshold</varname> (<type>integer</type>)
+ <term><varname>autovacuum_vacuum_insert_threshold</varname> (<type>integer</type>) - default is 1000 tuples
<indexterm>
<primary><varname>autovacuum_vacuum_insert_threshold</varname></primary>
<secondary>configuration parameter</secondary>
@@ -8603,7 +8603,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-analyze-threshold" xreflabel="autovacuum_analyze_threshold">
- <term><varname>autovacuum_analyze_threshold</varname> (<type>integer</type>)
+ <term><varname>autovacuum_analyze_threshold</varname> (<type>integer</type>) - default is 50 tuples
<indexterm>
<primary><varname>autovacuum_analyze_threshold</varname></primary>
<secondary>configuration parameter</secondary>
@@ -8623,7 +8623,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-vacuum-scale-factor" xreflabel="autovacuum_vacuum_scale_factor">
- <term><varname>autovacuum_vacuum_scale_factor</varname> (<type>floating point</type>)
+ <term><varname>autovacuum_vacuum_scale_factor</varname> (<type>floating point</type>) - default is 0.2
<indexterm>
<primary><varname>autovacuum_vacuum_scale_factor</varname></primary>
<secondary>configuration parameter</secondary>
@@ -8644,7 +8644,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-vacuum-insert-scale-factor" xreflabel="autovacuum_vacuum_insert_scale_factor">
- <term><varname>autovacuum_vacuum_insert_scale_factor</varname> (<type>floating point</type>)
+ <term><varname>autovacuum_vacuum_insert_scale_factor</varname> (<type>floating point</type>) - default is 0.2
<indexterm>
<primary><varname>autovacuum_vacuum_insert_scale_factor</varname></primary>
<secondary>configuration parameter</secondary>
@@ -8665,7 +8665,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-analyze-scale-factor" xreflabel="autovacuum_analyze_scale_factor">
- <term><varname>autovacuum_analyze_scale_factor</varname> (<type>floating point</type>)
+ <term><varname>autovacuum_analyze_scale_factor</varname> (<type>floating point</type>) - default is 0.1
<indexterm>
<primary><varname>autovacuum_analyze_scale_factor</varname></primary>
<secondary>configuration parameter</secondary>
@@ -8744,7 +8744,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-vacuum-cost-delay" xreflabel="autovacuum_vacuum_cost_delay">
- <term><varname>autovacuum_vacuum_cost_delay</varname> (<type>floating point</type>)
+ <term><varname>autovacuum_vacuum_cost_delay</varname> (<type>floating point</type>) - default is 2 miliseconds
<indexterm>
<primary><varname>autovacuum_vacuum_cost_delay</varname></primary>
<secondary>configuration parameter</secondary>
@@ -8766,7 +8766,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-autovacuum-vacuum-cost-limit" xreflabel="autovacuum_vacuum_cost_limit">
- <term><varname>autovacuum_vacuum_cost_limit</varname> (<type>integer</type>)
+ <term><varname>autovacuum_vacuum_cost_limit</varname> (<type>integer</type>) - default is -1
<indexterm>
<primary><varname>autovacuum_vacuum_cost_limit</varname></primary>
<secondary>configuration parameter</secondary>
@@ -8829,7 +8829,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
<variablelist>
<varlistentry id="guc-vacuum-cost-delay" xreflabel="vacuum_cost_delay">
- <term><varname>vacuum_cost_delay</varname> (<type>floating point</type>)
+ <term><varname>vacuum_cost_delay</varname> (<type>floating point</type>) - default is 0
<indexterm>
<primary><varname>vacuum_cost_delay</varname> configuration parameter</primary>
</indexterm>
@@ -8859,7 +8859,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-vacuum-cost-page-hit" xreflabel="vacuum_cost_page_hit">
- <term><varname>vacuum_cost_page_hit</varname> (<type>integer</type>)
+ <term><varname>vacuum_cost_page_hit</varname> (<type>integer</type>) - default is 1
<indexterm>
<primary><varname>vacuum_cost_page_hit</varname> configuration parameter</primary>
</indexterm>
@@ -8875,7 +8875,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-vacuum-cost-page-miss" xreflabel="vacuum_cost_page_miss">
- <term><varname>vacuum_cost_page_miss</varname> (<type>integer</type>)
+ <term><varname>vacuum_cost_page_miss</varname> (<type>integer</type>) - default is 2
<indexterm>
<primary><varname>vacuum_cost_page_miss</varname> configuration parameter</primary>
</indexterm>
@@ -8892,7 +8892,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-vacuum-cost-page-dirty" xreflabel="vacuum_cost_page_dirty">
- <term><varname>vacuum_cost_page_dirty</varname> (<type>integer</type>)
+ <term><varname>vacuum_cost_page_dirty</varname> (<type>integer</type>) - default is 20
<indexterm>
<primary><varname>vacuum_cost_page_dirty</varname> configuration parameter</primary>
</indexterm>
@@ -8908,7 +8908,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
</varlistentry>
<varlistentry id="guc-vacuum-cost-limit" xreflabel="vacuum_cost_limit">
- <term><varname>vacuum_cost_limit</varname> (<type>integer</type>)
+ <term><varname>vacuum_cost_limit</varname> (<type>integer</type>) - default is 200
<indexterm>
<primary><varname>vacuum_cost_limit</varname> configuration parameter</primary>
</indexterm>
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Better visualization of default values
In-Reply-To: <CAB-JLwZ5h=my4eeqe0KM=K6hR66nsA1Wea0ATQAt=Shh_Ji2pw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox