Summary of Configuration Parameters v11

Suggest edits

This section contains a summary table listing all Advanced Server configuration parameters along with a number of key attributes of the parameters.

These attributes are described by the following columns of the summary table:

Parameter. Configuration parameter name.
Scope of Effect. Scope of effect of the configuration parameter setting.
- Cluster – Setting affects the entire database cluster (that is, all databases managed by the database server instance).
- Database – Setting can vary by database and is established when the database is created. Applies to a small number of parameters related to locale settings.
- Session – Setting can vary down to the granularity of individual sessions.
In other words, different settings can be made for the following entities whereby the latter settings in this list override prior ones: a) the entire database cluster, b) specific databases in the database cluster, c) specific roles, d) specific roles when connected to specific databases, e) a specific session.
When Takes Effect. When a changed parameter setting takes effect.
- Preset – Established when the Advanced Server product is built or a particular database is created. This is a read-only parameter and cannot be changed.
- Restart – Database server must be restarted.
- Reload – Configuration file must be reloaded (or the database server can be restarted).
- Immediate – Immediately effective in a session if the PGOPTIONS environment variable or the SET command is used to change the setting in the current session. Effective in new sessions if ALTER DATABASE, ALTER ROLE, or ALTER ROLE IN DATABASE commands are used to change the setting.
Authorized User. Type of operating system account or database role that must be used to put the parameter setting into effect.
- EPAS service account – EDB Postgres Advanced Server service account (enterprisedb for an installation compatible with Oracle databases, postgres for a PostgreSQL compatible mode installation).
- Superuser – Database role with superuser privileges.
- User – Any database role with permissions on the affected database object (the database or role to be altered with the ALTER command).
- n/a – Parameter setting cannot be changed by any user.
Description. Brief description of the configuration parameter.
EPAS Only. ‘X’ – Configuration parameter is applicable to EDB Postgres Advanced Server only. No entry in this column indicates the configuration parameter applies to PostgreSQL as well.

Note

There are a number of parameters that should never be altered. These are designated as “Note: For internal use only” in the Description column.

The following table shows the summary of configuration parameters:

Parameter	Scope of Effect	When Takes Effect	Authorized User	Description	EPAS Only
`allow_system_table_mods`	Cluster	Restart	EPAS service account	Allows modifications of the structure of system tables.
`application_name`	Session	Immediate	User	Sets the application name to be reported in statistics and logs.
`archive_command`	Cluster	Reload	EPAS service account	Sets the shell command that will be called to archive a WAL file.
`archive_mode`	Cluster	Restart	EPAS service account	Allows archiving of WAL files using `archive_command`.
`archive_timeout`	Cluster	Reload	EPAS service account	Forces a switch to the next xlog file if a new file has not been started within N seconds.
`array_nulls`	Session	Immediate	User	Enable input of NULL elements in arrays.
`authentication_timeout`	Cluster	Reload	EPAS service account	Sets the maximum allowed time to complete client authentication.
`autovacuum`	Cluster	Reload	EPAS service account	Starts the autovacuum subprocess.
`autovacuum_analyze_scale_factor`	Cluster	Reload	EPAS service account	Number of tuple inserts, updates, or deletes prior to analyze as a fraction of `reltuples`.
`autovacuum_analyze_threshold`	Cluster	Reload	EPAS service account	Minimum number of tuple inserts, updates, or deletes prior to analyze.
`autovacuum_freeze_max_age`	Cluster	Restart	EPAS service account	Age at which to autovacuum a table to prevent transaction ID wraparound.
`autovacuum_max_workers`	Cluster	Restart	EPAS service account	Sets the maximum number of simultaneously running autovacuum worker processes.
`autovacuum_multixact_freeze_max_age`	Cluster	Restart	EPAS service account	Multixact age at which to autovacuum a table to prevent multixact wraparound.
`autovacuum_naptime`	Cluster	Reload	EPAS service account	Time to sleep between autovacuum runs.
`autovacuum_vacuum_cost_delay`	Cluster	Reload	EPAS service account	Vacuum cost delay in milliseconds, for autovacuum.
`autovacuum_vacuum_cost_limit`	Cluster	Reload	EPAS service account	Vacuum cost amount available before napping, for autovacuum.
`autovacuum_vacuum_scale_factor`	Cluster	Reload	EPAS service account	Number of tuple updates or deletes prior to vacuum as a fraction of `reltuples`.
`autovacuum_vacuum_threshold`	Cluster	Reload	EPAS service account	Minimum number of tuple updates or deletes prior to vacuum.
`autovacuum_work_mem`	Cluster	Reload	EPAS service account	Sets the maximum memory to be used by each autovacuum worker process.
`backslash_quote`	Session	Immediate	User	Sets whether `"\'"` is allowed in string literals.
`bgwriter_delay`	Cluster	Reload	EPAS service account	Background writer sleep time between rounds.
`bgwriter_lru_maxpages`	Cluster	Reload	EPAS service account	Background writer maximum number of LRU pages to flush per round.
`bgwriter_lru_multiplier`	Cluster	Reload	EPAS service account	Multiple of the average buffer usage to free per round.
`block_size`	Cluster	Preset	n/a	Shows the size of a disk block.
`bonjour`	Cluster	Restart	EPAS service account	Enables advertising the server via Bonjour.
`bonjour_name`	Cluster	Restart	EPAS service account	Sets the Bonjour service name.
`bytea_output`	Session	Immediate	User	Sets the output format for `bytea`.
`check_function_bodies`	Session	Immediate	User	Check function bodies during `CREATE FUNCTION`.
`checkpoint_completion_target`	Cluster	Reload	EPAS service account	Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.
`checkpoint_segments`	Deprecated	Deprecated	Deprecated	Specifying a value for the parameter will prevent the server from starting.
`checkpoint_timeout`	Cluster	Reload	EPAS service account	Sets the maximum time between automatic WAL checkpoints.
`checkpoint_warning`	Cluster	Reload	EPAS service account	Enables warnings if checkpoint segments are filled more frequently than this.
`client_encoding`	Session	Immediate	User	Sets the client's character set encoding.
`client_min_messages`	Session	Immediate	User	Sets the message levels that are sent to the client.
`commit_delay`	Session	Immediate	Superuser	Sets the delay in microseconds between transaction commit and flushing WAL to disk.
`commit_siblings`	Session	Immediate	User	Sets the minimum concurrent open transactions before performing `commit_delay`.
`config_file`	Cluster	Restart	EPAS service account	Sets the server's main configuration file.
`constraint_exclusion`	Session	Immediate	User	Enables the planner to use constraints to optimize queries.
`cpu_index_tuple_cost`	Session	Immediate	User	Sets the planner's estimate of the cost of processing each index entry during an index scan.
`cpu_operator_cost`	Session	Immediate	User	Sets the planner's estimate of the cost of processing each operator or function call.
`cpu_tuple_cost`	Session	Immediate	User	Sets the planner's estimate of the cost of processing each tuple (row).
`cursor_tuple_fraction`	Session	Immediate	User	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.
`custom_variable_classes`	Cluster	Reload	EPAS service account	Deprecated in Advanced Server 9.2.	X
`data_checksums`	Cluster	Preset	n/a	Shows whether data checksums are turned on for this cluster.
`data_directory`	Cluster	Restart	EPAS service account	Sets the server's data directory.
`datestyle`	Session	Immediate	User	Sets the display format for date and time values.
`db_dialect`	Session	Immediate	User	Sets the precedence of built-in namespaces.	X
`dbms_alert.max_alerts`	Cluster	Restart	EPAS service account	Sets maximum number of alerts.	X
`dbms_pipe.total_message_buffer`	Cluster	Restart	EPAS service account	Specifies the total size of the buffer used for the `DBMS_PIPE` package.	X
`db_user_namespace`	Cluster	Reload	EPAS service account	Enables per-database user names.
`deadlock_timeout`	Session	Immediate	Superuser	Sets the time to wait on a lock before checking for deadlock.
`debug_assertions`	Cluster	Preset	n/a	Turns on various assertion checks. (Not supported in EPAS builds.)
`debug_pretty_print`	Session	Immediate	User	Indents parse and plan tree displays.
`debug_print_parse`	Session	Immediate	User	Logs each query's parse tree.
`debug_print_plan`	Session	Immediate	User	Logs each query's execution plan.
`debug_print_rewritten`	Session	Immediate	User	Logs each query's rewritten parse tree.
`default_heap_fillfactor`	Session	Immediate	User	Create new tables with this heap fillfactor by default.	X
`default_statistics_target`	Session	Immediate	User	Sets the default statistics target.
`default_tablespace`	Session	Immediate	User	Sets the default tablespace to create tables and indexes in.
`default_text_search_config`	Session	Immediate	User	Sets default text search configuration.
`default_transaction_deferrable`	Session	Immediate	User	Sets the default deferrable status of new transactions.
`default_transaction_isolation`	Session	Immediate	User	Sets the transaction isolation level of each new transaction.
`default_transaction_read_only`	Session	Immediate	User	Sets the default read-only status of new transactions.
`default_with_oids`	Session	Immediate	User	Create new tables with OIDs by default.
`default_with_rowids`	Session	Immediate	User	Create new tables with ROWID support (ROWIDs with indexes) by default.	X
`dynamic_library_path`	Session	Immediate	Superuser	Sets the path for dynamically loadable modules.
`dynamic_shared_memory_type`	Cluster	Restart	EPAS service account	Selects the dynamic shared memory implementation used.
`edb_audit`	Cluster	Reload	EPAS service account	Enable EDB Auditing to create audit reports in XML or CSV format.	X
`edb_audit_connect`	Cluster	Reload	EPAS service account	Audits each successful connection.	X
`edb_audit_destination`	Cluster	Reload	EPAS service account	Sets `edb_audit_directory` or syslog as the destination directory for audit files. The syslog setting is only valid for a Linux system.	X
`edb_audit_directory`	Cluster	Reload	EPAS service account	Sets the destination directory for audit files.	X
`edb_audit_disconnect`	Cluster	Reload	EPAS service account	Audits end of a session.	X
`edb_audit_filename`	Cluster	Reload	EPAS service account	Sets the file name pattern for audit files.	X
`edb_audit_rotation_day`	Cluster	Reload	EPAS service account	Automatic rotation of log files based on day of week.	X
`edb_audit_rotation_seconds`	Cluster	Reload	EPAS service account	Automatic log file rotation will occur after N seconds.	X
`edb_audit_rotation_size`	Cluster	Reload	EPAS service account	Automatic log file rotation will occur after N Megabytes.	X
`edb_audit_statement`	Cluster	Reload	EPAS service account	Sets the type of statements to audit.	X
`edb_audit_tag`	Session	Immediate	User	Specify a tag to be included in the audit log.	X
`edb_connectby_order`	Session	Immediate	User	Sort results of `CONNECT BY` queries with no `ORDER BY` to depth-first order. Note: For internal use only.	X
`edb_custom_plan_tries`	Session	Immediate	User	Specifies the number of custom execution plans considered by the planner before the planner selects a generic execution plan.	X
`edb_data_redaction`	Session	Immediate	User	Enable data redaction.	X
`edb_dynatune`	Cluster	Restart	EPAS service account	Sets the edb utilization percentage.	X
`edb_dynatune_profile`	Cluster	Restart	EPAS service account	Sets the workload profile for dynatune.	X
`edb_enable_pruning`	Session	Immediate	User	Enables the planner to early-prune partitioned tables.	X
`edb_log_every_bulk_value`	Session	Immediate	Superuser	Sets the statements logged for bulk processing.	X
`edb_max_resource_groups`	Cluster	Restart	EPAS service account	Specifies the maximum number of resource groups for simultaneous use.	X
`edb_max_spins_per_delay`	Cluster	Restart	EPAS service account	Specifies the number of times a session will spin while waiting for a lock.	X
`edb_redwood_date`	Session	Immediate	User	Determines whether `DATE` should behave like a `TIMESTAMP` or not.	X
`edb_redwood_greatest_least`	Session	Immediate	User	Determines how `GREATEST` and `LEAST` functions should handle NULL parameters.	X
`edb_redwood_raw_names`	Session	Immediate	User	Return the unmodified name stored in the PostgreSQL system catalogs from Redwood interfaces.	X
`edb_redwood_strings`	Session	Immediate	User	Treat `NULL` as an empty string when concatenated with a text value.	X
`edb_resource_group`	Session	Immediate	User	Specifies the resource group to be used by the current process.	X
`edb_sql_protect.enabled`	Cluster	Reload	EPAS service account	Defines whether SQL/Protect should track queries or not.	X
`edb_sql_protect.level`	Cluster	Reload	EPAS service account	Defines the behavior of SQL/Protect when an event is found.	X
`edb_sql_protect.max_protected_relations`	Cluster	Restart	EPAS service account	Sets the maximum number of relations protected by SQL/Protect per role.	X
`edb_sql_protect.max_protected_roles`	Cluster	Restart	EPAS service account	Sets the maximum number of roles protected by SQL/Protect.	X
`edb_sql_protect.max_queries_to_save`	Cluster	Restart	EPAS service account	Sets the maximum number of offending queries to save by SQL/Protect.	X
`edb_stmt_level_tx`	Session	Immediate	User	Allows continuing on errors instead of requiring a transaction abort.	X
`edb_wait_states.directory`	Cluster	Restart	EPAS service account	The EDB wait states logs are stored in this directory.	X
`edb_wait_states.retention_period`	Cluster	Reload	EPAS service account	EDB wait state log files will be automatically deleted after retention period.	X
`edb_wait_states.sampling_interval`	Cluster	Reload	EPAS service account	The interval between two EDB wait state sampling cycles.	X
`edbldr.empty_csv_field`	Session	Immediate	Superuser	Specifies how EDB*Loader handles empty strings.	X
`effective_cache_size`	Session	Immediate	User	Sets the planner's assumption about the size of the disk cache.
`effective_io_concurrency`	Session	Immediate	User	Number of simultaneous requests that can be handled efficiently by the disk subsystem.
`enable_bitmapscan`	Session	Immediate	User	Enables the planner's use of bitmap-scan plans.
`enable_hashagg`	Session	Immediate	User	Enables the planner's use of hashed aggregation plans.
`enable_hashjoin`	Session	Immediate	User	Enables the planner's use of hash join plans.
`enable_hints`	Session	Immediate	User	Enable optimizer hints in SQL statements.	X
`enable_indexonlyscan`	Session	Immediate	User	Enables the planner’s use of index-only-scan plans.
`enable_indexscan`	Session	Immediate	User	Enables the planner's use of index-scan plans.
`enable_material`	Session	Immediate	User	Enables the planner's use of materialization.
`enable_mergejoin`	Session	Immediate	User	Enables the planner's use of merge join plans.
`enable_nestloop`	Session	Immediate	User	Enables the planner's use of nested-loop join plans.
`enable_seqscan`	Session	Immediate	User	Enables the planner's use of sequential-scan plans.
`enable_sort`	Session	Immediate	User	Enables the planner's use of explicit sort steps.
`enable_tidscan`	Session	Immediate	User	Enables the planner's use of TID scan plans.
`escape_string_warning`	Session	Immediate	User	Warn about backslash escapes in ordinary string literals.
`event_source`	Cluster	Restart	EPAS service account	Sets the application name used to identify PostgreSQL messages in the event log.
`exit_on_error`	Session	Immediate	User	Terminate session on any error.
`external_pid_file`	Cluster	Restart	EPAS service account	Writes the postmaster PID to the specified file.
`extra_float_digits`	Session	Immediate	User	Sets the number of digits displayed for floating-point values.
`from_collapse_limit`	Session	Immediate	User	Sets the `FROM`-list size beyond which subqueries are not collapsed.
`fsync`	Cluster	Reload	EPAS service account	Forces synchronization of updates to disk.
`full_page_writes`	Cluster	Reload	EPAS service account	Writes full pages to WAL when first modified after a checkpoint.
`geqo`	Session	Immediate	User	Enables genetic query optimization.
`geqo_effort`	Session	Immediate	User	GEQO: effort is used to set the default for other GEQO parameters.
`geqo_generations`	Session	Immediate	User	GEQO: number of iterations of the algorithm.
`geqo_pool_size`	Session	Immediate	User	GEQO: number of individuals in the population.
`geqo_seed`	Session	Immediate	User	GEQO: seed for random path selection.
`geqo_selection_bias`	Session	Immediate	User	GEQO: selective pressure within the population.
`geqo_threshold`	Session	Immediate	User	Sets the threshold of `FROM` items beyond which GEQO is used.
`gin_fuzzy_search_limit`	Session	Immediate	User	Sets the maximum allowed result for exact search by GIN.
`hba_file`	Cluster	Restart	EPAS service account	Sets the server's "hba" configuration file.
`hot_standby`	Cluster	Restart	EPAS service account	Allows connections and queries during recovery.
`hot_standby_feedback`	Cluster	Reload	EPAS service account	Allows feedback from a hot standby to the primary that will avoid query conflicts.
`huge_pages`	Cluster	Restart	EPAS service account	Use of huge pages on Linux.
`icu_short_form`	Database	Preset	n/a	Shows the ICU collation order configuration.	X
`ident_file`	Cluster	Restart	EPAS service account	Sets the server's "ident" configuration file.
`ignore_checksum_failure`	Session	Immediate	Superuser	Continues processing after a checksum failure.
`ignore_system_indexes`	Cluster/Session	Reload/Immediate	EPAS service account/User	Disables reading from system indexes. (Can also be set with `PGOPTIONS` at session start.)
`index_advisor.enabled`	Session	Immediate	User	Enable Index Advisor plugin.	X
`integer_datetimes`	Cluster	Preset	n/a	Datetimes are integer based.
`intervalStyle`	Session	Immediate	User	Sets the display format for interval values.
`join_collapse_limit`	Session	Immediate	User	Sets the `FROM`-list size beyond which `JOIN` constructs are not flattened.
`krb_caseins_users`	Cluster	Reload	EPAS service account	Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.
`krb_server_keyfile`	Cluster	Reload	EPAS service account	Sets the location of the Kerberos server key file.
`lc_collate`	Database	Preset	n/a	Shows the collation order locale.
`lc_ctype`	Database	Preset	n/a	Shows the character classification and case conversion locale.
`lc_messages`	Session	Immediate	Superuser	Sets the language in which messages are displayed.
`lc_monetary`	Session	Immediate	User	Sets the locale for formatting monetary amounts.
`lc_numeric`	Session	Immediate	User	Sets the locale for formatting numbers.
`lc_time`	Session	Immediate	User	Sets the locale for formatting date and time values.
`listen_addresses`	Cluster	Restart	EPAS service account	Sets the host name or IP address(es) to listen to.
`local_preload_libraries`	Cluster/Session	Reload/Immediate	EPAS service account/User	Lists shared libraries to preload into each backend. (Can also be set with `PGOPTIONS` at session start.)
`lock_timeout`	Session	Immediate	User	Sets the maximum time allowed that a statement may wait for a lock.
`lo_compat_privileges`	Session	Immediate	Superuser	Enables backward compatibility mode for privilege checks on large objects.
`log_autovacuum_min_duration`	Cluster	Reload	EPAS service account	Sets the minimum execution time above which autovacuum actions will be logged.
`log_checkpoints`	Cluster	Reload	EPAS service account	Logs each checkpoint.
`log_connections`	Cluster/Session	Reload/Immediate	EPAS service account/User	Logs each successful connection. (Can also be set with `PGOPTIONS` at session start.)
`log_destination`	Cluster	Reload	EPAS service account	Sets the destination for server log output.
`log_directory`	Cluster	Reload	EPAS service account	Sets the destination directory for log files.
`log_disconnections`	Cluster/Session	Reload/Immediate	EPAS service account/User	Logs end of a session, including duration. (Can also be set with `PGOPTIONS` at session start.)
`log_duration`	Session	Immediate	Superuser	Logs the duration of each completed SQL statement.
`log_error_verbosity`	Session	Immediate	Superuser	Sets the verbosity of logged messages.
`log_executor_stats`	Session	Immediate	Superuser	Writes executor performance statistics to the server log.
`log_file_mode`	Cluster	Reload	EPAS service account	Sets the file permissions for log files.
`log_filename`	Cluster	Reload	EPAS service account	Sets the file name pattern for log files.
`log_hostname`	Cluster	Reload	EPAS service account	Logs the host name in the connection logs.
`log_line_prefix`	Cluster	Reload	EPAS service account	Controls information prefixed to each log line.
`log_lock_waits`	Session	Immediate	Superuser	Logs long lock waits.
`log_min_duration_statement`	Session	Immediate	Superuser	Sets the minimum execution time above which statements will be logged.
`log_min_error_statement`	Session	Immediate	Superuser	Causes all statements generating error at or above this level to be logged.
`log_min_messages`	Session	Immediate	Superuser	Sets the message levels that are logged.
`log_parser_stats`	Session	Immediate	Superuser	Writes parser performance statistics to the server log.
`log_planner_stats`	Session	Immediate	Superuser	Writes planner performance statistics to the server log.
`log_rotation_age`	Cluster	Reload	EPAS service account	Automatic log file rotation will occur after N minutes.
`log_rotation_size`	Cluster	Reload	EPAS service account	Automatic log file rotation will occur after N kilobytes.
`log_statement`	Session	Immediate	Superuser	Sets the type of statements logged.
`log_statement_stats`	Session	Immediate	Superuser	Writes cumulative performance statistics to the server log.
`log_temp_files`	Session	Immediate	Superuser	Log the use of temporary files larger than this number of kilobytes.
`log_timezone`	Cluster	Reload	EPAS service account	Sets the time zone to use in log messages.
`log_truncate_on_rotation`	Cluster	Reload	EPAS service account	Truncate existing log files of same name during log rotation.
`logging_collector`	Cluster	Restart	EPAS service account	Start a subprocess to capture stderr output and/or csv logs into log files.
`maintenance_work_mem`	Session	Immediate	User	Sets the maximum memory to be used for maintenance operations.
`max_connections`	Cluster	Restart	EPAS service account	Sets the maximum number of concurrent connections.
`max_files_per_process`	Cluster	Restart	EPAS service account	Sets the maximum number of simultaneously open files for each server process.
`max_function_args`	Cluster	Preset	n/a	Shows the maximum number of function arguments.
`max_identifier_length`	Cluster	Preset	n/a	Shows the maximum identifier length.
`max_index_keys`	Cluster	Preset	n/a	Shows the maximum number of index keys.
`max_locks_per_transaction`	Cluster	Restart	EPAS service account	Sets the maximum number of locks per transaction.
`max_pred_locks_per_transaction`	Cluster	Restart	EPAS service account	Sets the maximum number of predicate locks per transaction.
`max_prepared_transactions`	Cluster	Restart	EPAS service account	Sets the maximum number of simultaneously prepared transactions.
`max_replication_slots`	Cluster	Restart	EPAS service account	Sets the maximum number of simultaneously defined replication slots.
`max_stack_depth`	Session	Immediate	Superuser	Sets the maximum stack depth, in kilobytes.
`max_standby_archive_delay`	Cluster	Reload	EPAS service account	Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.
`max_standby_streaming_delay`	Cluster	Reload	EPAS service account	Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.
`max_wal_senders`	Cluster	Restart	EPAS service account	Sets the maximum number of simultaneously running WAL sender processes.
`max_wal_size`	Cluster	Reload	EPAS service account	Sets the maximum size to which the WAL will grow between automatic WAL checkpoints. The default is 1GB.
`max_worker_processes`	Cluster	Restart	EPAS service account	Maximum number of concurrent worker processes.
`min_wal_size`	Cluster	Reload	EPAS service account	Sets the threshold at which WAL logs will be recycled rather than removed. The default is 80 MB.
`nls_length_semantics`	Session	Immediate	Superuser	Sets the semantics to use for char, varchar, varchar2 and long columns.	X
`odbc_lib_path`	Cluster	Restart	EPAS service account	Sets the path for ODBC library.	X
`optimizer_mode`	Session	Immediate	User	Default optimizer mode.	X
`oracle_home`	Cluster	Restart	EPAS service account	Sets the path for the Oracle home directory.	X
`password_encryption`	Session	Immediate	User	Encrypt passwords.
`pg_prewarm.autoprewarm`	Cluster	Restart	EPAS service account	Enables the `autoprewarm` background worker.	X
`pg_prewarm.autoprewarm_interval`	Cluster	Reload	EPAS service account	Sets the minimum number of seconds after which `autoprewarm` dumps shared buffers.	X
`port`	Cluster	Restart	EPAS service account	Sets the TCP port on which the server listens.
`post_auth_delay`	Cluster/Session	Reload/Immediate	EPAS service account/User	Waits N seconds on connection startup after authentication. (Can also be set with `PGOPTIONS` at session start.)
`pre_auth_delay`	Cluster	Reload	EPAS service account	Waits N seconds on connection startup before authentication.
`qreplace_function`	Session	Immediate	Superuser	The function to be used by Query Replace feature. Note: For internal use only.	X
`query_rewrite_enabled`	Session	Immediate	User	Child table scans will be skipped if their constraints guarantee that no rows match the query.	X
`query_rewrite_integrity`	Session	Immediate	Superuser	Sets the degree to which query rewriting must be enforced.	X
`quote_all_identifiers`	Session	Immediate	User	When generating SQL fragments, quote all identifiers.
`random_page_cost`	Session	Immediate	User	Sets the planner's estimate of the cost of a nonsequentially fetched disk page.
`restart_after_crash`	Cluster	Reload	EPAS service account	Reinitialize server after backend crash.
`search_path`	Session	Immediate	User	Sets the schema search order for names that are not schema-qualified.
`segment_size`	Cluster	Preset	n/a	Shows the number of pages per disk file.
`seq_page_cost`	Session	Immediate	User	Sets the planner's estimate of the cost of a sequentially fetched disk page.
`server_encoding`	Database	Preset	n/a	Sets the server (database) character set encoding.
`server_version`	Cluster	Preset	n/a	Shows the server version.
`server_version_num`	Cluster	Preset	n/a	Shows the server version as an integer.
`session_preload_libraries`	Session	Immediate but only at connection start	Superuser	Lists shared libraries to preload into each backend.
`session_replication_role`	Session	Immediate	Superuser	Sets the session's behavior for triggers and rewrite rules.
`shared_buffers`	Cluster	Restart	EPAS service account	Sets the number of shared memory buffers used by the server.
`shared_preload_libraries`	Cluster	Restart	EPAS service account	Lists shared libraries to preload into server.
`sql_inheritance`	Session	Immediate	User	Causes subtables to be included by default in various commands.
`ssl`	Cluster	Reload	EPAS service account	Enables SSL connections.
`ssl_ca_file`	Cluster	Reload	EPAS service account	Location of the SSL certificate authority file.
`ssl_cert_file`	Cluster	Reload	EPAS service account	Location of the SSL server certificate file.
`ssl_ciphers`	Cluster	Reload	EPAS service account	Sets the list of allowed SSL ciphers.
`ssl_crl_file`	Cluster	Reload	EPAS service account	Location of the SSL certificate revocation list file.
`ssl_ecdh_curve`	Cluster	Reload	EPAS service account	Sets the curve to use for ECDH.
`ssl_key_file`	Cluster	Reload	EPAS service account	Location of the SSL server private key file.
`ssl_prefer_server_ciphers`	Cluster	Reload	EPAS service account	Give priority to server ciphersuite order.
`ssl_renegotiation_limit`	Session	Immediate	User	Set the amount of traffic to send and receive before renegotiating the encryption keys.
`standard_conforming_strings`	Session	Immediate	User	Causes '...' strings to treat backslashes literally.
`statement_timeout`	Session	Immediate	User	Sets the maximum allowed duration of any statement.
`stats_temp_directory`	Cluster	Reload	EPAS service account	Writes temporary statistics files to the specified directory.
`superuser_reserved_connections`	Cluster	Restart	EPAS service account	Sets the number of connection slots reserved for superusers.
`synchronize_seqscans`	Session	Immediate	User	Enable synchronized sequential scans.
`synchronous_commit`	Session	Immediate	User	Sets immediate fsync at commit.
`synchronous_standby_names`	Cluster	Reload	EPAS service account	List of names of potential synchronous standbys.
`syslog_facility`	Cluster	Reload	EPAS service account	Sets the syslog "facility" to be used when syslog enabled.
`syslog_ident`	Cluster	Reload	EPAS service account	Sets the program name used to identify PostgreSQL messages in syslog.
`tcp_keepalives_count`	Session	Immediate	User	Maximum number of TCP keepalive retransmits.
`tcp_keepalives_idle`	Session	Immediate	User	Time between issuing TCP keepalives.
`tcp_keepalives_interval`	Session	Immediate	User	Time between TCP keepalive retransmits.
`temp_buffers`	Session	Immediate	User	Sets the maximum number of temporary buffers used by each session.
`temp_file_limit`	Session	Immediate	Superuser	Limits the total size of all temporary files used by each session.
`temp_tablespaces`	Session	Immediate	User	Sets the tablespace(s) to use for temporary tables and sort files.
`timed_statistics`	Session	Immediate	User	Enables the recording of timed statistics.	X
`timezone`	Session	Immediate	User	Sets the time zone for displaying and interpreting time stamps.
`timezone_abbreviations`	Session	Immediate	User	Selects a file of time zone abbreviations.
`trace_hints`	Session	Immediate	User	Emit debug info about hints being honored.	X
`trace_notify`	Session	Immediate	User	Generates debugging output for `LISTEN` and `NOTIFY`.
`trace_recovery_messages`	Cluster	Reload	EPAS service account	Enables logging of recovery-related debugging information.
`trace_sort`	Session	Immediate	User	Emit information about resource usage in sorting.
`track_activities`	Session	Immediate	Superuser	Collects information about executing commnands.
`track_activity_query_size`	Cluster	Restart	EPAS service account	Sets the size reserved for `pg_stat_activity.current_query`, in bytes.
`track_counts`	Session	Immediate	Superuser	Collects statistics on database activity.
`track_functions`	Session	Immediate	Superuser	Collects function-level statistics on database activity.
`track_io_timing`	Session	Immediate	Superuser	Collects timing statistics for database I/O activity.
`transaction_deferrable`	Session	Immediate	User	Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
`transaction_isolation`	Session	Immediate	User	Sets the current transaction's isolation level.
`transaction_read_only`	Session	Immediate	User	Sets the current transaction's read-only status.
`transform_null_equals`	Session	Immediate	User	Treats `"expr=NULL"` as `"expr IS NULL"`.
`unix_socket_directories`	Cluster	Restart	EPAS service account	Sets the directory where the Unix-domain socket will be created.
`unix_socket_group`	Cluster	Restart	EPAS service account	Sets the owning group of the Unix-domain socket.
`unix_socket_permissions`	Cluster	Restart	EPAS service account	Sets the access permissions of the Unix-domain socket.
`update_process_title`	Session	Immediate	Superuser	Updates the process title to show the active SQL command.
`utl_encode.uudecode_redwood`	Session	Immediate	User	Allows decoding of Oracle-created uuencoded data.	X
`utl_file.umask`	Session	Immediate	User	Umask used for files created through the `UTL_FILE` package.	X
`vacuum_cost_delay`	Session	Immediate	User	Vacuum cost delay in milliseconds.
`vacuum_cost_limit`	Session	Immediate	User	Vacuum cost amount available before napping.
`vacuum_cost_page_dirty`	Session	Immediate	User	Vacuum cost for a page dirtied by vacuum.
`vacuum_cost_page_hit`	Session	Immediate	User	Vacuum cost for a page found in the buffer cache.
`vacuum_cost_page_miss`	Session	Immediate	User	Vacuum cost for a page not found in the buffer cache.
`vacuum_defer_cleanup_age`	Cluster	Reload	EPAS service account	Number of transactions by which `VACUUM` and `HOT` cleanup should be deferred, if any.
`vacuum_freeze_min_age`	Session	Immediate	User	Minimum age at which `VACUUM` should freeze a table row.
`vacuum_freeze_table_age`	Session	Immediate	User	Age at which `VACUUM` should scan whole table to freeze tuples.
`vacuum_multixact_freeze_min_age`	Session	Immediate	User	Minimum age at which `VACUUM` should freeze a MultiXactId in a table row.
`vacuum_multixact_freeze_table_age`	Session	Immediate	User	Multixact age at which `VACUUM` should scan whole table to freeze tuples.
`wal_block_size`	Cluster	Preset	n/a	Shows the block size in the write ahead log.
`wal_buffers`	Cluster	Restart	EPAS service account	Sets the number of disk-page buffers in shared memory for WAL.
`wal_keep_segments`	Cluster	Reload	EPAS service account	Sets the number of WAL files held for standby servers.
`wal_level`	Cluster	Restart	EPAS service account	Set the level of information written to the WAL.
`wal_log_hints`	Cluster	Restart	EPAS service account	Writes full pages to WAL when first modified after a checkpoint, even for non-critical modifications.
`wal_receiver_status_interval`	Cluster	Reload	EPAS service account	Sets the maximum interval between WAL receiver status reports to the primary.
`wal_receiver_timeout`	Cluster	Reload	EPAS service account	Sets the maximum wait time to receive data from the primary.
`wal_segment_size`	Cluster	Preset	n/a	Shows the number of pages per write ahead log segment.
`wal_sender_timeout`	Cluster	Reload	EPAS service account	Sets the maximum time to wait for WAL replication.
`wal_sync_method`	Cluster	Reload	EPAS service account	Selects the method used for forcing WAL updates to disk.
`wal_writer_delay`	Cluster	Reload	EPAS service account	WAL writer sleep time between WAL flushes.
`work_mem`	Session	Immediate	User	Sets the maximum memory to be used for query workspaces.
`xloginsert_locks`	Cluster	Restart	EPAS service account	Sets the number of locks used for concurrent xlog insertions.
`xmlbinary`	Session	Immediate	User	Sets how binary values are to be encoded in XML.
`xmloption`	Session	Immediate	User	Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
`zero_damaged_pages`	Session	Immediate	Superuser	Continues processing past damaged page headers.

← Prev

Setting Configuration Parameters

↑ Up

Configuration Parameters

Configuration Parameters by Functionality

Summary of Configuration Parameters v11

Note

← Prev

↑ Up

Next →