hnwwansjdmaglo

Untitled

Oct 12th, 2022
214
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 27.87 KB | None | 0 0
  1. # SHOW ALL;
  2.  
  3. name setting description
  4.  
  5. allow_system_table_mods off Allows modifications of the structure of system tables.
  6. application_name Adminer Sets the application name to be reported in statistics and logs.
  7. archive_cleanup_command "" Sets the shell command that will be executed at every restart point.
  8. archive_command (disabled) Sets the shell command that will be called to archive a WAL file.
  9. archive_mode off Allows archiving of WAL files using archive_command.
  10. archive_timeout "0" Forces a switch to the next WAL file if a new file has not been started within N seconds.
  11. array_nulls on Enable input of NULL elements in arrays.
  12. authentication_timeout 1min Sets the maximum allowed time to complete client authentication.
  13. autovacuum on Starts the autovacuum subprocess.
  14. autovacuum_analyze_scale_factor "0.1" "Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples."
  15. autovacuum_analyze_threshold 50 "Minimum number of tuple inserts, updates, or deletes prior to analyze."
  16. autovacuum_freeze_max_age 200000000 Age at which to autovacuum a table to prevent transaction ID wraparound.
  17. autovacuum_max_workers 3 Sets the maximum number of simultaneously running autovacuum worker processes.
  18. autovacuum_multixact_freeze_max_age 400000000 Multixact age at which to autovacuum a table to prevent multixact wraparound.
  19. autovacuum_naptime 1min Time to sleep between autovacuum runs.
  20. autovacuum_vacuum_cost_delay 2ms "Vacuum cost delay in milliseconds, for autovacuum."
  21. autovacuum_vacuum_cost_limit -1 "Vacuum cost amount available before napping, for autovacuum."
  22. autovacuum_vacuum_insert_scale_factor "0.2" Number of tuple inserts prior to vacuum as a fraction of reltuples.
  23. autovacuum_vacuum_insert_threshold 1000 "Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums."
  24. autovacuum_vacuum_scale_factor "0.2" Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.
  25. autovacuum_vacuum_threshold 50 Minimum number of tuple updates or deletes prior to vacuum.
  26. autovacuum_work_mem -1 Sets the maximum memory to be used by each autovacuum worker process.
  27. backend_flush_after "0" Number of pages after which previously performed writes are flushed to disk.
  28. backslash_quote safe_encoding "Sets whether ""\'"" is allowed in string literals."
  29. backtrace_functions "" Log backtrace for errors in these functions.
  30. bgwriter_delay 200ms Background writer sleep time between rounds.
  31. bgwriter_flush_after 512kB Number of pages after which previously performed writes are flushed to disk.
  32. bgwriter_lru_maxpages 100 Background writer maximum number of LRU pages to flush per round.
  33. bgwriter_lru_multiplier 2 Multiple of the average buffer usage to free per round.
  34. block_size 8192 Shows the size of a disk block.
  35. bonjour off Enables advertising the server via Bonjour.
  36. bonjour_name "" Sets the Bonjour service name.
  37. bytea_output hex Sets the output format for bytea.
  38. check_function_bodies on Check routine bodies during CREATE FUNCTION and CREATE PROCEDURE.
  39. checkpoint_completion_target "0.9" "Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval."
  40. checkpoint_flush_after 256kB Number of pages after which previously performed writes are flushed to disk.
  41. checkpoint_timeout 5min Sets the maximum time between automatic WAL checkpoints.
  42. checkpoint_warning 30s Enables warnings if checkpoint segments are filled more frequently than this.
  43. client_connection_check_interval "0" Sets the time interval between checks for disconnection while running queries.
  44. client_encoding UTF8 Sets the client's character set encoding.
  45. client_min_messages notice Sets the message levels that are sent to the client.
  46. cluster_name "" "Sets the name of the cluster, which is included in the process title."
  47. commit_delay "0" Sets the delay in microseconds between transaction commit and flushing WAL to disk.
  48. commit_siblings 5 Sets the minimum concurrent open transactions before performing commit_delay.
  49. compute_query_id auto Compute query identifiers.
  50. config_file /pgdata/postgresql.conf Sets the server's main configuration file.
  51. constraint_exclusion partition Enables the planner to use constraints to optimize queries.
  52. cpu_index_tuple_cost "0.005" Sets the planner's estimate of the cost of processing each index entry during an index scan.
  53. cpu_operator_cost "0.0025" Sets the planner's estimate of the cost of processing each operator or function call.
  54. cpu_tuple_cost "0.01" Sets the planner's estimate of the cost of processing each tuple (row).
  55. cursor_tuple_fraction "0.1" Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
  56. data_checksums off Shows whether data checksums are turned on for this cluster.
  57. data_directory /pgdata Sets the server's data directory.
  58. data_directory_mode "0700" Shows the mode of the data directory.
  59. data_sync_retry off Whether to continue running after a failure to sync data files.
  60. DateStyle "ISO, MDY" Sets the display format for date and time values.
  61. db_user_namespace off Enables per-database user names.
  62. deadlock_timeout 1s Sets the time to wait on a lock before checking for deadlock.
  63. debug_assertions off Shows whether the running server has assertion checks enabled.
  64. debug_discard_caches "0" Aggressively flush system caches for debugging purposes.
  65. debug_pretty_print on Indents parse and plan tree displays.
  66. debug_print_parse off Logs each query's parse tree.
  67. debug_print_plan off Logs each query's execution plan.
  68. debug_print_rewritten off Logs each query's rewritten parse tree.
  69. default_statistics_target 100 Sets the default statistics target.
  70. default_table_access_method heap Sets the default table access method for new tables.
  71. default_tablespace "" Sets the default tablespace to create tables and indexes in.
  72. default_text_search_config pg_catalog.english Sets default text search configuration.
  73. default_toast_compression pglz Sets the default compression method for compressible values.
  74. default_transaction_deferrable off Sets the default deferrable status of new transactions.
  75. default_transaction_isolation read committed Sets the transaction isolation level of each new transaction.
  76. default_transaction_read_only off Sets the default read-only status of new transactions.
  77. dynamic_library_path $libdir Sets the path for dynamically loadable modules.
  78. dynamic_shared_memory_type posix Selects the dynamic shared memory implementation used.
  79. effective_cache_size 1GB Sets the planner's assumption about the total size of the data caches.
  80. effective_io_concurrency 1 Number of simultaneous requests that can be handled efficiently by the disk subsystem.
  81. enable_async_append on Enables the planner's use of async append plans.
  82. enable_bitmapscan on Enables the planner's use of bitmap-scan plans.
  83. enable_gathermerge on Enables the planner's use of gather merge plans.
  84. enable_hashagg on Enables the planner's use of hashed aggregation plans.
  85. enable_hashjoin on Enables the planner's use of hash join plans.
  86. enable_incremental_sort on Enables the planner's use of incremental sort steps.
  87. enable_indexonlyscan on Enables the planner's use of index-only-scan plans.
  88. enable_indexscan on Enables the planner's use of index-scan plans.
  89. enable_material on Enables the planner's use of materialization.
  90. enable_memoize on Enables the planner's use of memoization.
  91. enable_mergejoin on Enables the planner's use of merge join plans.
  92. enable_nestloop on Enables the planner's use of nested-loop join plans.
  93. enable_parallel_append on Enables the planner's use of parallel append plans.
  94. enable_parallel_hash on Enables the planner's use of parallel hash plans.
  95. enable_partition_pruning on Enables plan-time and execution-time partition pruning.
  96. enable_partitionwise_aggregate off Enables partitionwise aggregation and grouping.
  97. enable_partitionwise_join off Enables partitionwise join.
  98. enable_seqscan on Enables the planner's use of sequential-scan plans.
  99. enable_sort on Enables the planner's use of explicit sort steps.
  100. enable_tidscan on Enables the planner's use of TID scan plans.
  101. escape_string_warning on Warn about backslash escapes in ordinary string literals.
  102. event_source PostgreSQL Sets the application name used to identify PostgreSQL messages in the event log.
  103. exit_on_error off Terminate session on any error.
  104. external_pid_file "" Writes the postmaster PID to the specified file.
  105. extra_float_digits 1 Sets the number of digits displayed for floating-point values.
  106. force_parallel_mode off Forces use of parallel query facilities.
  107. from_collapse_limit 8 Sets the FROM-list size beyond which subqueries are not collapsed.
  108. fsync on Forces synchronization of updates to disk.
  109. full_page_writes on Writes full pages to WAL when first modified after a checkpoint.
  110. geqo on Enables genetic query optimization.
  111. geqo_effort 5 GEQO: effort is used to set the default for other GEQO parameters.
  112. geqo_generations "0" GEQO: number of iterations of the algorithm.
  113. geqo_pool_size "0" GEQO: number of individuals in the population.
  114. geqo_seed "0" GEQO: seed for random path selection.
  115. geqo_selection_bias 2 GEQO: selective pressure within the population.
  116. geqo_threshold 12 Sets the threshold of FROM items beyond which GEQO is used.
  117. gin_fuzzy_search_limit "0" Sets the maximum allowed result for exact search by GIN.
  118. gin_pending_list_limit 4MB Sets the maximum size of the pending list for GIN index.
  119. hash_mem_multiplier 1 Multiple of work_mem to use for hash tables.
  120. hba_file /pgdata/pg_hba.conf "Sets the server's ""hba"" configuration file."
  121. hot_standby on Allows connections and queries during recovery.
  122. hot_standby_feedback off Allows feedback from a hot standby to the primary that will avoid query conflicts.
  123. huge_page_size "0" The size of huge page that should be requested.
  124. huge_pages try Use of huge pages on Linux or Windows.
  125. ident_file /pgdata/pg_ident.conf "Sets the server's ""ident"" configuration file."
  126. idle_in_transaction_session_timeout "0" "Sets the maximum allowed idle time between queries, when in a transaction."
  127. idle_session_timeout "0" "Sets the maximum allowed idle time between queries, when not in a transaction."
  128. ignore_checksum_failure off Continues processing after a checksum failure.
  129. ignore_invalid_pages off Continues recovery after an invalid pages failure.
  130. ignore_system_indexes off Disables reading from system indexes.
  131. in_hot_standby off Shows whether hot standby is currently active.
  132. integer_datetimes on Shows whether datetimes are integer based.
  133. IntervalStyle postgres Sets the display format for interval values.
  134. jit on Allow JIT compilation.
  135. jit_above_cost 100000 Perform JIT compilation if query is more expensive.
  136. jit_debugging_support off Register JIT-compiled functions with debugger.
  137. jit_dump_bitcode off Write out LLVM bitcode to facilitate JIT debugging.
  138. jit_expressions on Allow JIT compilation of expressions.
  139. jit_inline_above_cost 500000 Perform JIT inlining if query is more expensive.
  140. jit_optimize_above_cost 500000 Optimize JIT-compiled functions if query is more expensive.
  141. jit_profiling_support off Register JIT-compiled functions with perf profiler.
  142. jit_provider llvmjit JIT provider to use.
  143. jit_tuple_deforming on Allow JIT compilation of tuple deforming.
  144. join_collapse_limit 8 Sets the FROM-list size beyond which JOIN constructs are not flattened.
  145. krb_caseins_users off Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.
  146. krb_server_keyfile FILE:/usr/local/etc/postgresql/krb5.keytab Sets the location of the Kerberos server key file.
  147. lc_collate en_US.utf8 Shows the collation order locale.
  148. lc_ctype en_US.utf8 Shows the character classification and case conversion locale.
  149. lc_messages en_US.utf8 Sets the language in which messages are displayed.
  150. lc_monetary en_US.utf8 Sets the locale for formatting monetary amounts.
  151. lc_numeric en_US.utf8 Sets the locale for formatting numbers.
  152. lc_time en_US.utf8 Sets the locale for formatting date and time values.
  153. listen_addresses * Sets the host name or IP address(es) to listen to.
  154. lo_compat_privileges off Enables backward compatibility mode for privilege checks on large objects.
  155. local_preload_libraries "" Lists unprivileged shared libraries to preload into each backend.
  156. lock_timeout "0" Sets the maximum allowed duration of any wait for a lock.
  157. log_autovacuum_min_duration -1 Sets the minimum execution time above which autovacuum actions will be logged.
  158. log_checkpoints off Logs each checkpoint.
  159. log_connections off Logs each successful connection.
  160. log_destination stderr Sets the destination for server log output.
  161. log_directory log Sets the destination directory for log files.
  162. log_disconnections off "Logs end of a session, including duration."
  163. log_duration on Logs the duration of each completed SQL statement.
  164. log_error_verbosity default Sets the verbosity of logged messages.
  165. log_executor_stats off Writes executor performance statistics to the server log.
  166. log_file_mode "0600" Sets the file permissions for log files.
  167. log_filename postgresql-%Y-%m-%d_%H%M%S.log Sets the file name pattern for log files.
  168. log_hostname on Logs the host name in the connection logs.
  169. log_line_prefix %m [%p] Controls information prefixed to each log line.
  170. log_lock_waits off Logs long lock waits.
  171. log_min_duration_sample -1 Sets the minimum execution time above which a sample of statements will be logged. Sampling is determined by log_statement_sample_rate.
  172. log_min_duration_statement 10s Sets the minimum execution time above which all statements will be logged.
  173. log_min_error_statement warning Causes all statements generating error at or above this level to be logged.
  174. log_min_messages warning Sets the message levels that are logged.
  175. log_parameter_max_length -1 "When logging statements, limit logged parameter values to first N bytes."
  176. log_parameter_max_length_on_error "0" "When reporting an error, limit logged parameter values to first N bytes."
  177. log_parser_stats off Writes parser performance statistics to the server log.
  178. log_planner_stats off Writes planner performance statistics to the server log.
  179. log_recovery_conflict_waits off Logs standby recovery conflict waits.
  180. log_replication_commands off Logs each replication command.
  181. log_rotation_age 1d Automatic log file rotation will occur after N minutes.
  182. log_rotation_size 100MB Automatic log file rotation will occur after N kilobytes.
  183. log_statement none Sets the type of statements logged.
  184. log_statement_sample_rate 1 Fraction of statements exceeding log_min_duration_sample to be logged.
  185. log_statement_stats off Writes cumulative performance statistics to the server log.
  186. log_temp_files -1 Log the use of temporary files larger than this number of kilobytes.
  187. log_timezone UTC Sets the time zone to use in log messages.
  188. log_transaction_sample_rate "0" Sets the fraction of transactions from which to log all statements.
  189. log_truncate_on_rotation off Truncate existing log files of same name during log rotation.
  190. logging_collector off Start a subprocess to capture stderr output and/or csvlogs into log files.
  191. logical_decoding_work_mem 64MB Sets the maximum memory to be used for logical decoding.
  192. maintenance_io_concurrency 10 A variant of effective_io_concurrency that is used for maintenance work.
  193. maintenance_work_mem 200MB Sets the maximum memory to be used for maintenance operations.
  194. max_connections 100 Sets the maximum number of concurrent connections.
  195. max_files_per_process 1000 Sets the maximum number of simultaneously open files for each server process.
  196. max_function_args 100 Shows the maximum number of function arguments.
  197. max_identifier_length 63 Shows the maximum identifier length.
  198. max_index_keys 32 Shows the maximum number of index keys.
  199. max_locks_per_transaction 64 Sets the maximum number of locks per transaction.
  200. max_logical_replication_workers 4 Maximum number of logical replication worker processes.
  201. max_parallel_maintenance_workers 2 Sets the maximum number of parallel processes per maintenance operation.
  202. max_parallel_workers 8 Sets the maximum number of parallel workers that can be active at one time.
  203. max_parallel_workers_per_gather 2 Sets the maximum number of parallel processes per executor node.
  204. max_pred_locks_per_page 2 Sets the maximum number of predicate-locked tuples per page.
  205. max_pred_locks_per_relation -2 Sets the maximum number of predicate-locked pages and tuples per relation.
  206. max_pred_locks_per_transaction 64 Sets the maximum number of predicate locks per transaction.
  207. max_prepared_transactions "0" Sets the maximum number of simultaneously prepared transactions.
  208. max_replication_slots 10 Sets the maximum number of simultaneously defined replication slots.
  209. max_slot_wal_keep_size -1 Sets the maximum WAL size that can be reserved by replication slots.
  210. max_stack_depth 2MB "Sets the maximum stack depth, in kilobytes."
  211. max_standby_archive_delay 30s Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.
  212. max_standby_streaming_delay 30s Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.
  213. max_sync_workers_per_subscription 2 Maximum number of table synchronization workers per subscription.
  214. max_wal_senders 10 Sets the maximum number of simultaneously running WAL sender processes.
  215. max_wal_size 1GB Sets the WAL size that triggers a checkpoint.
  216. max_worker_processes 8 Maximum number of concurrent worker processes.
  217. min_dynamic_shared_memory "0" Amount of dynamic shared memory reserved at startup.
  218. min_parallel_index_scan_size 512kB Sets the minimum amount of index data for a parallel scan.
  219. min_parallel_table_scan_size 8MB Sets the minimum amount of table data for a parallel scan.
  220. min_wal_size 80MB Sets the minimum size to shrink the WAL to.
  221. old_snapshot_threshold -1 Time before a snapshot is too old to read pages changed after the snapshot was taken.
  222. parallel_leader_participation on Controls whether Gather and Gather Merge also run subplans.
  223. parallel_setup_cost 1000 Sets the planners estimate of the cost of starting up worker processes for parallel query.
  224. parallel_tuple_cost "0.1" Sets the planners estimate of the cost of passing each tuple (row) from worker to leader backend.
  225. password_encryption scram-sha-256 Chooses the algorithm for encrypting passwords.
  226. plan_cache_mode auto Controls the planners selection of custom or generic plan.
  227. port 5432 Sets the TCP port the server listens on.
  228. post_auth_delay "0" Waits N seconds on connection startup after authentication.
  229. pre_auth_delay "0" Waits N seconds on connection startup before authentication.
  230. primary_conninfo "" Sets the connection string to be used to connect to the sending server.
  231. primary_slot_name "" Sets the name of the replication slot to use on the sending server.
  232. promote_trigger_file "" Specifies a file name whose presence ends recovery in the standby.
  233. quote_all_identifiers off "When generating SQL fragments, quote all identifiers."
  234. random_page_cost 4 Sets the planner's estimate of the cost of a nonsequentially fetched disk page.
  235. recovery_end_command "" Sets the shell command that will be executed once at the end of recovery.
  236. recovery_init_sync_method fsync Sets the method for synchronizing the data directory before crash recovery.
  237. recovery_min_apply_delay "0" Sets the minimum delay for applying changes during recovery.
  238. recovery_target "" "Set to ""immediate"" to end recovery as soon as a consistent state is reached."
  239. recovery_target_action pause Sets the action to perform upon reaching the recovery target.
  240. recovery_target_inclusive on Sets whether to include or exclude transaction with recovery target.
  241. recovery_target_lsn "" Sets the LSN of the write-ahead log location up to which recovery will proceed.
  242. recovery_target_name "" Sets the named restore point up to which recovery will proceed.
  243. recovery_target_time "" Sets the time stamp up to which recovery will proceed.
  244. recovery_target_timeline latest Specifies the timeline to recover into.
  245. recovery_target_xid "" Sets the transaction ID up to which recovery will proceed.
  246. remove_temp_files_after_crash on Remove temporary files after backend crash.
  247. restart_after_crash on Reinitialize server after backend crash.
  248. restore_command "" Sets the shell command that will be called to retrieve an archived WAL file.
  249. row_security on Enable row security.
  250. search_path public Sets the schema search order for names that are not schema-qualified.
  251. segment_size 1GB Shows the number of pages per disk file.
  252. seq_page_cost 1 Sets the planner's estimate of the cost of a sequentially fetched disk page.
  253. server_encoding UTF8 Shows the server (database) character set encoding.
  254. server_version 14.1 Shows the server version.
  255. server_version_num 140001 Shows the server version as an integer.
  256. session_preload_libraries "" Lists shared libraries to preload into each backend.
  257. session_replication_role origin Sets the session's behavior for triggers and rewrite rules.
  258. shared_buffers 400MB Sets the number of shared memory buffers used by the server.
  259. shared_memory_type mmap Selects the shared memory implementation used for the main shared memory region.
  260. shared_preload_libraries "" Lists shared libraries to preload into server.
  261. ssl off Enables SSL connections.
  262. ssl_ca_file "" Location of the SSL certificate authority file.
  263. ssl_cert_file server.crt Location of the SSL server certificate file.
  264. ssl_ciphers HIGH:MEDIUM:+3DES:!aNULL Sets the list of allowed SSL ciphers.
  265. ssl_crl_dir "" Location of the SSL certificate revocation list directory.
  266. ssl_crl_file "" Location of the SSL certificate revocation list file.
  267. ssl_dh_params_file "" Location of the SSL DH parameters file.
  268. ssl_ecdh_curve prime256v1 Sets the curve to use for ECDH.
  269. ssl_key_file server.key Location of the SSL server private key file.
  270. ssl_library OpenSSL Shows the name of the SSL library.
  271. ssl_max_protocol_version "" Sets the maximum SSL/TLS protocol version to use.
  272. ssl_min_protocol_version TLSv1.2 Sets the minimum SSL/TLS protocol version to use.
  273. ssl_passphrase_command "" Command to obtain passphrases for SSL.
  274. ssl_passphrase_command_supports_reload off Also use ssl_passphrase_command during server reload.
  275. ssl_prefer_server_ciphers on Give priority to server ciphersuite order.
  276. standard_conforming_strings on Causes '...' strings to treat backslashes literally.
  277. statement_timeout "0" Sets the maximum allowed duration of any statement.
  278. stats_temp_directory pg_stat_tmp Writes temporary statistics files to the specified directory.
  279. superuser_reserved_connections 3 Sets the number of connection slots reserved for superusers.
  280. synchronize_seqscans on Enable synchronized sequential scans.
  281. synchronous_commit on Sets the current transaction's synchronization level.
  282. synchronous_standby_names "" Number of synchronous standbys and list of names of potential synchronous ones.
  283. syslog_facility local0 "Sets the syslog ""facility"" to be used when syslog enabled."
  284. syslog_ident postgres Sets the program name used to identify PostgreSQL messages in syslog.
  285. syslog_sequence_numbers on Add sequence number to syslog messages to avoid duplicate suppression.
  286. syslog_split_messages off Split messages sent to syslog by lines and to fit into 1024 bytes.
  287. tcp_keepalives_count 9 Maximum number of TCP keepalive retransmits.
  288. tcp_keepalives_idle 7200 Time between issuing TCP keepalives.
  289. tcp_keepalives_interval 75 Time between TCP keepalive retransmits.
  290. tcp_user_timeout "0" TCP user timeout.
  291. temp_buffers 8MB Sets the maximum number of temporary buffers used by each session.
  292. temp_file_limit -1 Limits the total size of all temporary files used by each process.
  293. temp_tablespaces "" Sets the tablespace(s) to use for temporary tables and sort files.
  294. TimeZone UTC Sets the time zone for displaying and interpreting time stamps.
  295. timezone_abbreviations Default Selects a file of time zone abbreviations.
  296. trace_notify off Generates debugging output for LISTEN and NOTIFY.
  297. trace_recovery_messages log Enables logging of recovery-related debugging information.
  298. trace_sort off Emit information about resource usage in sorting.
  299. track_activities on Collects information about executing commands.
  300. track_activity_query_size 1kB "Sets the size reserved for pg_stat_activity.query, in bytes."
  301. track_commit_timestamp off Collects transaction commit time.
  302. track_counts on Collects statistics on database activity.
  303. track_functions none Collects function-level statistics on database activity.
  304. track_io_timing off Collects timing statistics for database I/O activity.
  305. track_wal_io_timing off Collects timing statistics for WAL I/O activity.
  306. transaction_deferrable off Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
  307. transaction_isolation read committed Sets the current transaction's isolation level.
  308. transaction_read_only off Sets the current transaction's read-only status.
  309. transform_null_equals off "Treats ""expr=NULL"" as ""expr IS NULL""."
  310. unix_socket_directories /var/run/postgresql Sets the directories where Unix-domain sockets will be created.
  311. unix_socket_group "" Sets the owning group of the Unix-domain socket.
  312. unix_socket_permissions "0777" Sets the access permissions of the Unix-domain socket.
  313. update_process_title on Updates the process title to show the active SQL command.
  314. vacuum_cost_delay "0" Vacuum cost delay in milliseconds.
  315. vacuum_cost_limit 200 Vacuum cost amount available before napping.
  316. vacuum_cost_page_dirty 20 Vacuum cost for a page dirtied by vacuum.
  317. vacuum_cost_page_hit 1 Vacuum cost for a page found in the buffer cache.
  318. vacuum_cost_page_miss 2 Vacuum cost for a page not found in the buffer cache.
  319. vacuum_defer_cleanup_age "0" "Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."
  320. vacuum_failsafe_age 1600000000 Age at which VACUUM should trigger failsafe to avoid a wraparound outage.
  321. vacuum_freeze_min_age 50000000 Minimum age at which VACUUM should freeze a table row.
  322. vacuum_freeze_table_age 150000000 Age at which VACUUM should scan whole table to freeze tuples.
  323. vacuum_multixact_failsafe_age 1600000000 Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage.
  324. vacuum_multixact_freeze_min_age 5000000 Minimum age at which VACUUM should freeze a MultiXactId in a table row.
  325. vacuum_multixact_freeze_table_age 150000000 Multixact age at which VACUUM should scan whole table to freeze tuples.
  326. wal_block_size 8192 Shows the block size in the write ahead log.
  327. wal_buffers 12800kB Sets the number of disk-page buffers in shared memory for WAL.
  328. wal_compression off Compresses full-page writes written in WAL file.
  329. wal_consistency_checking "" Sets the WAL resource managers for which WAL consistency checks are done.
  330. wal_init_zero on Writes zeroes to new WAL files before first use.
  331. wal_keep_size "0" Sets the size of WAL files held for standby servers.
  332. wal_level replica Sets the level of information written to the WAL.
  333. wal_log_hints off "Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modification."
  334. wal_receiver_create_temp_slot off Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.
  335. wal_receiver_status_interval 10s Sets the maximum interval between WAL receiver status reports to the sending server.
  336. wal_receiver_timeout 1min Sets the maximum wait time to receive data from the sending server.
  337. wal_recycle on Recycles WAL files by renaming them.
  338. wal_retrieve_retry_interval 5s Sets the time to wait before retrying to retrieve WAL after a failed attempt.
  339. wal_segment_size 16MB Shows the size of write ahead log segments.
  340. wal_sender_timeout 1min Sets the maximum time to wait for WAL replication.
  341. wal_skip_threshold 2MB Minimum size of new file to fsync instead of writing WAL.
  342. wal_sync_method fdatasync Selects the method used for forcing WAL updates to disk.
  343. wal_writer_delay 200ms Time between WAL flushes performed in the WAL writer.
  344. wal_writer_flush_after 1MB Amount of WAL written out by WAL writer that triggers a flush.
  345. work_mem 64MB Sets the maximum memory to be used for query workspaces.
  346. xmlbinary base64 Sets how binary values are to be encoded in XML.
  347. xmloption content Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
  348. zero_damaged_pages off Continues processing past damaged page headers.
Add Comment
Please, Sign In to add comment