Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # SHOW ALL;
- name setting description
- allow_system_table_mods off Allows modifications of the structure of system tables.
- application_name Adminer Sets the application name to be reported in statistics and logs.
- archive_cleanup_command "" Sets the shell command that will be executed at every restart point.
- archive_command (disabled) Sets the shell command that will be called to archive a WAL file.
- archive_mode off Allows archiving of WAL files using archive_command.
- archive_timeout "0" Forces a switch to the next WAL file if a new file has not been started within N seconds.
- array_nulls on Enable input of NULL elements in arrays.
- authentication_timeout 1min Sets the maximum allowed time to complete client authentication.
- autovacuum on Starts the autovacuum subprocess.
- autovacuum_analyze_scale_factor "0.1" "Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples."
- autovacuum_analyze_threshold 50 "Minimum number of tuple inserts, updates, or deletes prior to analyze."
- autovacuum_freeze_max_age 200000000 Age at which to autovacuum a table to prevent transaction ID wraparound.
- autovacuum_max_workers 3 Sets the maximum number of simultaneously running autovacuum worker processes.
- autovacuum_multixact_freeze_max_age 400000000 Multixact age at which to autovacuum a table to prevent multixact wraparound.
- autovacuum_naptime 1min Time to sleep between autovacuum runs.
- autovacuum_vacuum_cost_delay 2ms "Vacuum cost delay in milliseconds, for autovacuum."
- autovacuum_vacuum_cost_limit -1 "Vacuum cost amount available before napping, for autovacuum."
- autovacuum_vacuum_insert_scale_factor "0.2" Number of tuple inserts prior to vacuum as a fraction of reltuples.
- autovacuum_vacuum_insert_threshold 1000 "Minimum number of tuple inserts prior to vacuum, or -1 to disable insert vacuums."
- autovacuum_vacuum_scale_factor "0.2" Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.
- autovacuum_vacuum_threshold 50 Minimum number of tuple updates or deletes prior to vacuum.
- autovacuum_work_mem -1 Sets the maximum memory to be used by each autovacuum worker process.
- backend_flush_after "0" Number of pages after which previously performed writes are flushed to disk.
- backslash_quote safe_encoding "Sets whether ""\'"" is allowed in string literals."
- backtrace_functions "" Log backtrace for errors in these functions.
- bgwriter_delay 200ms Background writer sleep time between rounds.
- bgwriter_flush_after 512kB Number of pages after which previously performed writes are flushed to disk.
- bgwriter_lru_maxpages 100 Background writer maximum number of LRU pages to flush per round.
- bgwriter_lru_multiplier 2 Multiple of the average buffer usage to free per round.
- block_size 8192 Shows the size of a disk block.
- bonjour off Enables advertising the server via Bonjour.
- bonjour_name "" Sets the Bonjour service name.
- bytea_output hex Sets the output format for bytea.
- check_function_bodies on Check routine bodies during CREATE FUNCTION and CREATE PROCEDURE.
- checkpoint_completion_target "0.9" "Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval."
- checkpoint_flush_after 256kB Number of pages after which previously performed writes are flushed to disk.
- checkpoint_timeout 5min Sets the maximum time between automatic WAL checkpoints.
- checkpoint_warning 30s Enables warnings if checkpoint segments are filled more frequently than this.
- client_connection_check_interval "0" Sets the time interval between checks for disconnection while running queries.
- client_encoding UTF8 Sets the client's character set encoding.
- client_min_messages notice Sets the message levels that are sent to the client.
- cluster_name "" "Sets the name of the cluster, which is included in the process title."
- commit_delay "0" Sets the delay in microseconds between transaction commit and flushing WAL to disk.
- commit_siblings 5 Sets the minimum concurrent open transactions before performing commit_delay.
- compute_query_id auto Compute query identifiers.
- config_file /pgdata/postgresql.conf Sets the server's main configuration file.
- constraint_exclusion partition Enables the planner to use constraints to optimize queries.
- cpu_index_tuple_cost "0.005" Sets the planner's estimate of the cost of processing each index entry during an index scan.
- cpu_operator_cost "0.0025" Sets the planner's estimate of the cost of processing each operator or function call.
- cpu_tuple_cost "0.01" Sets the planner's estimate of the cost of processing each tuple (row).
- cursor_tuple_fraction "0.1" Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
- data_checksums off Shows whether data checksums are turned on for this cluster.
- data_directory /pgdata Sets the server's data directory.
- data_directory_mode "0700" Shows the mode of the data directory.
- data_sync_retry off Whether to continue running after a failure to sync data files.
- DateStyle "ISO, MDY" Sets the display format for date and time values.
- db_user_namespace off Enables per-database user names.
- deadlock_timeout 1s Sets the time to wait on a lock before checking for deadlock.
- debug_assertions off Shows whether the running server has assertion checks enabled.
- debug_discard_caches "0" Aggressively flush system caches for debugging purposes.
- debug_pretty_print on Indents parse and plan tree displays.
- debug_print_parse off Logs each query's parse tree.
- debug_print_plan off Logs each query's execution plan.
- debug_print_rewritten off Logs each query's rewritten parse tree.
- default_statistics_target 100 Sets the default statistics target.
- default_table_access_method heap Sets the default table access method for new tables.
- default_tablespace "" Sets the default tablespace to create tables and indexes in.
- default_text_search_config pg_catalog.english Sets default text search configuration.
- default_toast_compression pglz Sets the default compression method for compressible values.
- default_transaction_deferrable off Sets the default deferrable status of new transactions.
- default_transaction_isolation read committed Sets the transaction isolation level of each new transaction.
- default_transaction_read_only off Sets the default read-only status of new transactions.
- dynamic_library_path $libdir Sets the path for dynamically loadable modules.
- dynamic_shared_memory_type posix Selects the dynamic shared memory implementation used.
- effective_cache_size 1GB Sets the planner's assumption about the total size of the data caches.
- effective_io_concurrency 1 Number of simultaneous requests that can be handled efficiently by the disk subsystem.
- enable_async_append on Enables the planner's use of async append plans.
- enable_bitmapscan on Enables the planner's use of bitmap-scan plans.
- enable_gathermerge on Enables the planner's use of gather merge plans.
- enable_hashagg on Enables the planner's use of hashed aggregation plans.
- enable_hashjoin on Enables the planner's use of hash join plans.
- enable_incremental_sort on Enables the planner's use of incremental sort steps.
- enable_indexonlyscan on Enables the planner's use of index-only-scan plans.
- enable_indexscan on Enables the planner's use of index-scan plans.
- enable_material on Enables the planner's use of materialization.
- enable_memoize on Enables the planner's use of memoization.
- enable_mergejoin on Enables the planner's use of merge join plans.
- enable_nestloop on Enables the planner's use of nested-loop join plans.
- enable_parallel_append on Enables the planner's use of parallel append plans.
- enable_parallel_hash on Enables the planner's use of parallel hash plans.
- enable_partition_pruning on Enables plan-time and execution-time partition pruning.
- enable_partitionwise_aggregate off Enables partitionwise aggregation and grouping.
- enable_partitionwise_join off Enables partitionwise join.
- enable_seqscan on Enables the planner's use of sequential-scan plans.
- enable_sort on Enables the planner's use of explicit sort steps.
- enable_tidscan on Enables the planner's use of TID scan plans.
- escape_string_warning on Warn about backslash escapes in ordinary string literals.
- event_source PostgreSQL Sets the application name used to identify PostgreSQL messages in the event log.
- exit_on_error off Terminate session on any error.
- external_pid_file "" Writes the postmaster PID to the specified file.
- extra_float_digits 1 Sets the number of digits displayed for floating-point values.
- force_parallel_mode off Forces use of parallel query facilities.
- from_collapse_limit 8 Sets the FROM-list size beyond which subqueries are not collapsed.
- fsync on Forces synchronization of updates to disk.
- full_page_writes on Writes full pages to WAL when first modified after a checkpoint.
- geqo on Enables genetic query optimization.
- geqo_effort 5 GEQO: effort is used to set the default for other GEQO parameters.
- geqo_generations "0" GEQO: number of iterations of the algorithm.
- geqo_pool_size "0" GEQO: number of individuals in the population.
- geqo_seed "0" GEQO: seed for random path selection.
- geqo_selection_bias 2 GEQO: selective pressure within the population.
- geqo_threshold 12 Sets the threshold of FROM items beyond which GEQO is used.
- gin_fuzzy_search_limit "0" Sets the maximum allowed result for exact search by GIN.
- gin_pending_list_limit 4MB Sets the maximum size of the pending list for GIN index.
- hash_mem_multiplier 1 Multiple of work_mem to use for hash tables.
- hba_file /pgdata/pg_hba.conf "Sets the server's ""hba"" configuration file."
- hot_standby on Allows connections and queries during recovery.
- hot_standby_feedback off Allows feedback from a hot standby to the primary that will avoid query conflicts.
- huge_page_size "0" The size of huge page that should be requested.
- huge_pages try Use of huge pages on Linux or Windows.
- ident_file /pgdata/pg_ident.conf "Sets the server's ""ident"" configuration file."
- idle_in_transaction_session_timeout "0" "Sets the maximum allowed idle time between queries, when in a transaction."
- idle_session_timeout "0" "Sets the maximum allowed idle time between queries, when not in a transaction."
- ignore_checksum_failure off Continues processing after a checksum failure.
- ignore_invalid_pages off Continues recovery after an invalid pages failure.
- ignore_system_indexes off Disables reading from system indexes.
- in_hot_standby off Shows whether hot standby is currently active.
- integer_datetimes on Shows whether datetimes are integer based.
- IntervalStyle postgres Sets the display format for interval values.
- jit on Allow JIT compilation.
- jit_above_cost 100000 Perform JIT compilation if query is more expensive.
- jit_debugging_support off Register JIT-compiled functions with debugger.
- jit_dump_bitcode off Write out LLVM bitcode to facilitate JIT debugging.
- jit_expressions on Allow JIT compilation of expressions.
- jit_inline_above_cost 500000 Perform JIT inlining if query is more expensive.
- jit_optimize_above_cost 500000 Optimize JIT-compiled functions if query is more expensive.
- jit_profiling_support off Register JIT-compiled functions with perf profiler.
- jit_provider llvmjit JIT provider to use.
- jit_tuple_deforming on Allow JIT compilation of tuple deforming.
- join_collapse_limit 8 Sets the FROM-list size beyond which JOIN constructs are not flattened.
- krb_caseins_users off Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.
- krb_server_keyfile FILE:/usr/local/etc/postgresql/krb5.keytab Sets the location of the Kerberos server key file.
- lc_collate en_US.utf8 Shows the collation order locale.
- lc_ctype en_US.utf8 Shows the character classification and case conversion locale.
- lc_messages en_US.utf8 Sets the language in which messages are displayed.
- lc_monetary en_US.utf8 Sets the locale for formatting monetary amounts.
- lc_numeric en_US.utf8 Sets the locale for formatting numbers.
- lc_time en_US.utf8 Sets the locale for formatting date and time values.
- listen_addresses * Sets the host name or IP address(es) to listen to.
- lo_compat_privileges off Enables backward compatibility mode for privilege checks on large objects.
- local_preload_libraries "" Lists unprivileged shared libraries to preload into each backend.
- lock_timeout "0" Sets the maximum allowed duration of any wait for a lock.
- log_autovacuum_min_duration -1 Sets the minimum execution time above which autovacuum actions will be logged.
- log_checkpoints off Logs each checkpoint.
- log_connections off Logs each successful connection.
- log_destination stderr Sets the destination for server log output.
- log_directory log Sets the destination directory for log files.
- log_disconnections off "Logs end of a session, including duration."
- log_duration on Logs the duration of each completed SQL statement.
- log_error_verbosity default Sets the verbosity of logged messages.
- log_executor_stats off Writes executor performance statistics to the server log.
- log_file_mode "0600" Sets the file permissions for log files.
- log_filename postgresql-%Y-%m-%d_%H%M%S.log Sets the file name pattern for log files.
- log_hostname on Logs the host name in the connection logs.
- log_line_prefix %m [%p] Controls information prefixed to each log line.
- log_lock_waits off Logs long lock waits.
- 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.
- log_min_duration_statement 10s Sets the minimum execution time above which all statements will be logged.
- log_min_error_statement warning Causes all statements generating error at or above this level to be logged.
- log_min_messages warning Sets the message levels that are logged.
- log_parameter_max_length -1 "When logging statements, limit logged parameter values to first N bytes."
- log_parameter_max_length_on_error "0" "When reporting an error, limit logged parameter values to first N bytes."
- log_parser_stats off Writes parser performance statistics to the server log.
- log_planner_stats off Writes planner performance statistics to the server log.
- log_recovery_conflict_waits off Logs standby recovery conflict waits.
- log_replication_commands off Logs each replication command.
- log_rotation_age 1d Automatic log file rotation will occur after N minutes.
- log_rotation_size 100MB Automatic log file rotation will occur after N kilobytes.
- log_statement none Sets the type of statements logged.
- log_statement_sample_rate 1 Fraction of statements exceeding log_min_duration_sample to be logged.
- log_statement_stats off Writes cumulative performance statistics to the server log.
- log_temp_files -1 Log the use of temporary files larger than this number of kilobytes.
- log_timezone UTC Sets the time zone to use in log messages.
- log_transaction_sample_rate "0" Sets the fraction of transactions from which to log all statements.
- log_truncate_on_rotation off Truncate existing log files of same name during log rotation.
- logging_collector off Start a subprocess to capture stderr output and/or csvlogs into log files.
- logical_decoding_work_mem 64MB Sets the maximum memory to be used for logical decoding.
- maintenance_io_concurrency 10 A variant of effective_io_concurrency that is used for maintenance work.
- maintenance_work_mem 200MB Sets the maximum memory to be used for maintenance operations.
- max_connections 100 Sets the maximum number of concurrent connections.
- max_files_per_process 1000 Sets the maximum number of simultaneously open files for each server process.
- max_function_args 100 Shows the maximum number of function arguments.
- max_identifier_length 63 Shows the maximum identifier length.
- max_index_keys 32 Shows the maximum number of index keys.
- max_locks_per_transaction 64 Sets the maximum number of locks per transaction.
- max_logical_replication_workers 4 Maximum number of logical replication worker processes.
- max_parallel_maintenance_workers 2 Sets the maximum number of parallel processes per maintenance operation.
- max_parallel_workers 8 Sets the maximum number of parallel workers that can be active at one time.
- max_parallel_workers_per_gather 2 Sets the maximum number of parallel processes per executor node.
- max_pred_locks_per_page 2 Sets the maximum number of predicate-locked tuples per page.
- max_pred_locks_per_relation -2 Sets the maximum number of predicate-locked pages and tuples per relation.
- max_pred_locks_per_transaction 64 Sets the maximum number of predicate locks per transaction.
- max_prepared_transactions "0" Sets the maximum number of simultaneously prepared transactions.
- max_replication_slots 10 Sets the maximum number of simultaneously defined replication slots.
- max_slot_wal_keep_size -1 Sets the maximum WAL size that can be reserved by replication slots.
- max_stack_depth 2MB "Sets the maximum stack depth, in kilobytes."
- max_standby_archive_delay 30s Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.
- max_standby_streaming_delay 30s Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.
- max_sync_workers_per_subscription 2 Maximum number of table synchronization workers per subscription.
- max_wal_senders 10 Sets the maximum number of simultaneously running WAL sender processes.
- max_wal_size 1GB Sets the WAL size that triggers a checkpoint.
- max_worker_processes 8 Maximum number of concurrent worker processes.
- min_dynamic_shared_memory "0" Amount of dynamic shared memory reserved at startup.
- min_parallel_index_scan_size 512kB Sets the minimum amount of index data for a parallel scan.
- min_parallel_table_scan_size 8MB Sets the minimum amount of table data for a parallel scan.
- min_wal_size 80MB Sets the minimum size to shrink the WAL to.
- old_snapshot_threshold -1 Time before a snapshot is too old to read pages changed after the snapshot was taken.
- parallel_leader_participation on Controls whether Gather and Gather Merge also run subplans.
- parallel_setup_cost 1000 Sets the planners estimate of the cost of starting up worker processes for parallel query.
- parallel_tuple_cost "0.1" Sets the planners estimate of the cost of passing each tuple (row) from worker to leader backend.
- password_encryption scram-sha-256 Chooses the algorithm for encrypting passwords.
- plan_cache_mode auto Controls the planners selection of custom or generic plan.
- port 5432 Sets the TCP port the server listens on.
- post_auth_delay "0" Waits N seconds on connection startup after authentication.
- pre_auth_delay "0" Waits N seconds on connection startup before authentication.
- primary_conninfo "" Sets the connection string to be used to connect to the sending server.
- primary_slot_name "" Sets the name of the replication slot to use on the sending server.
- promote_trigger_file "" Specifies a file name whose presence ends recovery in the standby.
- quote_all_identifiers off "When generating SQL fragments, quote all identifiers."
- random_page_cost 4 Sets the planner's estimate of the cost of a nonsequentially fetched disk page.
- recovery_end_command "" Sets the shell command that will be executed once at the end of recovery.
- recovery_init_sync_method fsync Sets the method for synchronizing the data directory before crash recovery.
- recovery_min_apply_delay "0" Sets the minimum delay for applying changes during recovery.
- recovery_target "" "Set to ""immediate"" to end recovery as soon as a consistent state is reached."
- recovery_target_action pause Sets the action to perform upon reaching the recovery target.
- recovery_target_inclusive on Sets whether to include or exclude transaction with recovery target.
- recovery_target_lsn "" Sets the LSN of the write-ahead log location up to which recovery will proceed.
- recovery_target_name "" Sets the named restore point up to which recovery will proceed.
- recovery_target_time "" Sets the time stamp up to which recovery will proceed.
- recovery_target_timeline latest Specifies the timeline to recover into.
- recovery_target_xid "" Sets the transaction ID up to which recovery will proceed.
- remove_temp_files_after_crash on Remove temporary files after backend crash.
- restart_after_crash on Reinitialize server after backend crash.
- restore_command "" Sets the shell command that will be called to retrieve an archived WAL file.
- row_security on Enable row security.
- search_path public Sets the schema search order for names that are not schema-qualified.
- segment_size 1GB Shows the number of pages per disk file.
- seq_page_cost 1 Sets the planner's estimate of the cost of a sequentially fetched disk page.
- server_encoding UTF8 Shows the server (database) character set encoding.
- server_version 14.1 Shows the server version.
- server_version_num 140001 Shows the server version as an integer.
- session_preload_libraries "" Lists shared libraries to preload into each backend.
- session_replication_role origin Sets the session's behavior for triggers and rewrite rules.
- shared_buffers 400MB Sets the number of shared memory buffers used by the server.
- shared_memory_type mmap Selects the shared memory implementation used for the main shared memory region.
- shared_preload_libraries "" Lists shared libraries to preload into server.
- ssl off Enables SSL connections.
- ssl_ca_file "" Location of the SSL certificate authority file.
- ssl_cert_file server.crt Location of the SSL server certificate file.
- ssl_ciphers HIGH:MEDIUM:+3DES:!aNULL Sets the list of allowed SSL ciphers.
- ssl_crl_dir "" Location of the SSL certificate revocation list directory.
- ssl_crl_file "" Location of the SSL certificate revocation list file.
- ssl_dh_params_file "" Location of the SSL DH parameters file.
- ssl_ecdh_curve prime256v1 Sets the curve to use for ECDH.
- ssl_key_file server.key Location of the SSL server private key file.
- ssl_library OpenSSL Shows the name of the SSL library.
- ssl_max_protocol_version "" Sets the maximum SSL/TLS protocol version to use.
- ssl_min_protocol_version TLSv1.2 Sets the minimum SSL/TLS protocol version to use.
- ssl_passphrase_command "" Command to obtain passphrases for SSL.
- ssl_passphrase_command_supports_reload off Also use ssl_passphrase_command during server reload.
- ssl_prefer_server_ciphers on Give priority to server ciphersuite order.
- standard_conforming_strings on Causes '...' strings to treat backslashes literally.
- statement_timeout "0" Sets the maximum allowed duration of any statement.
- stats_temp_directory pg_stat_tmp Writes temporary statistics files to the specified directory.
- superuser_reserved_connections 3 Sets the number of connection slots reserved for superusers.
- synchronize_seqscans on Enable synchronized sequential scans.
- synchronous_commit on Sets the current transaction's synchronization level.
- synchronous_standby_names "" Number of synchronous standbys and list of names of potential synchronous ones.
- syslog_facility local0 "Sets the syslog ""facility"" to be used when syslog enabled."
- syslog_ident postgres Sets the program name used to identify PostgreSQL messages in syslog.
- syslog_sequence_numbers on Add sequence number to syslog messages to avoid duplicate suppression.
- syslog_split_messages off Split messages sent to syslog by lines and to fit into 1024 bytes.
- tcp_keepalives_count 9 Maximum number of TCP keepalive retransmits.
- tcp_keepalives_idle 7200 Time between issuing TCP keepalives.
- tcp_keepalives_interval 75 Time between TCP keepalive retransmits.
- tcp_user_timeout "0" TCP user timeout.
- temp_buffers 8MB Sets the maximum number of temporary buffers used by each session.
- temp_file_limit -1 Limits the total size of all temporary files used by each process.
- temp_tablespaces "" Sets the tablespace(s) to use for temporary tables and sort files.
- TimeZone UTC Sets the time zone for displaying and interpreting time stamps.
- timezone_abbreviations Default Selects a file of time zone abbreviations.
- trace_notify off Generates debugging output for LISTEN and NOTIFY.
- trace_recovery_messages log Enables logging of recovery-related debugging information.
- trace_sort off Emit information about resource usage in sorting.
- track_activities on Collects information about executing commands.
- track_activity_query_size 1kB "Sets the size reserved for pg_stat_activity.query, in bytes."
- track_commit_timestamp off Collects transaction commit time.
- track_counts on Collects statistics on database activity.
- track_functions none Collects function-level statistics on database activity.
- track_io_timing off Collects timing statistics for database I/O activity.
- track_wal_io_timing off Collects timing statistics for WAL I/O activity.
- transaction_deferrable off Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
- transaction_isolation read committed Sets the current transaction's isolation level.
- transaction_read_only off Sets the current transaction's read-only status.
- transform_null_equals off "Treats ""expr=NULL"" as ""expr IS NULL""."
- unix_socket_directories /var/run/postgresql Sets the directories where Unix-domain sockets will be created.
- unix_socket_group "" Sets the owning group of the Unix-domain socket.
- unix_socket_permissions "0777" Sets the access permissions of the Unix-domain socket.
- update_process_title on Updates the process title to show the active SQL command.
- vacuum_cost_delay "0" Vacuum cost delay in milliseconds.
- vacuum_cost_limit 200 Vacuum cost amount available before napping.
- vacuum_cost_page_dirty 20 Vacuum cost for a page dirtied by vacuum.
- vacuum_cost_page_hit 1 Vacuum cost for a page found in the buffer cache.
- vacuum_cost_page_miss 2 Vacuum cost for a page not found in the buffer cache.
- vacuum_defer_cleanup_age "0" "Number of transactions by which VACUUM and HOT cleanup should be deferred, if any."
- vacuum_failsafe_age 1600000000 Age at which VACUUM should trigger failsafe to avoid a wraparound outage.
- vacuum_freeze_min_age 50000000 Minimum age at which VACUUM should freeze a table row.
- vacuum_freeze_table_age 150000000 Age at which VACUUM should scan whole table to freeze tuples.
- vacuum_multixact_failsafe_age 1600000000 Multixact age at which VACUUM should trigger failsafe to avoid a wraparound outage.
- vacuum_multixact_freeze_min_age 5000000 Minimum age at which VACUUM should freeze a MultiXactId in a table row.
- vacuum_multixact_freeze_table_age 150000000 Multixact age at which VACUUM should scan whole table to freeze tuples.
- wal_block_size 8192 Shows the block size in the write ahead log.
- wal_buffers 12800kB Sets the number of disk-page buffers in shared memory for WAL.
- wal_compression off Compresses full-page writes written in WAL file.
- wal_consistency_checking "" Sets the WAL resource managers for which WAL consistency checks are done.
- wal_init_zero on Writes zeroes to new WAL files before first use.
- wal_keep_size "0" Sets the size of WAL files held for standby servers.
- wal_level replica Sets the level of information written to the WAL.
- wal_log_hints off "Writes full pages to WAL when first modified after a checkpoint, even for a non-critical modification."
- wal_receiver_create_temp_slot off Sets whether a WAL receiver should create a temporary replication slot if no permanent slot is configured.
- wal_receiver_status_interval 10s Sets the maximum interval between WAL receiver status reports to the sending server.
- wal_receiver_timeout 1min Sets the maximum wait time to receive data from the sending server.
- wal_recycle on Recycles WAL files by renaming them.
- wal_retrieve_retry_interval 5s Sets the time to wait before retrying to retrieve WAL after a failed attempt.
- wal_segment_size 16MB Shows the size of write ahead log segments.
- wal_sender_timeout 1min Sets the maximum time to wait for WAL replication.
- wal_skip_threshold 2MB Minimum size of new file to fsync instead of writing WAL.
- wal_sync_method fdatasync Selects the method used for forcing WAL updates to disk.
- wal_writer_delay 200ms Time between WAL flushes performed in the WAL writer.
- wal_writer_flush_after 1MB Amount of WAL written out by WAL writer that triggers a flush.
- work_mem 64MB Sets the maximum memory to be used for query workspaces.
- xmlbinary base64 Sets how binary values are to be encoded in XML.
- xmloption content Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
- zero_damaged_pages off Continues processing past damaged page headers.
Add Comment
Please, Sign In to add comment