Summary of configuration parameters v14

This section contains a summary table listing all EDB Postgres 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 EDB Postgres 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:

ParameterScope of effectWhen takes effectAuthorized

user
DescriptionEPAS only
allow_system_table_modsClusterRestartEPAS service accountAllows modifications of the structure of system tables.
application_nameSessionImmediateUserSets the application name to be reported in statistics and logs.
archive_commandClusterReloadEPAS service accountSets the shell command called to archive a WAL file.
archive_modeClusterRestartEPAS service accountAllows archiving of WAL files using archive_command.
archive_timeoutClusterReloadEPAS service accountForces a switch to the next xlog file if a new file has not been started within N seconds.
array_nullsSessionImmediateUserEnable input of NULL elements in arrays.
authentication_timeoutClusterReloadEPAS service accountSets the maximum allowed time to complete client authentication.
autovacuumClusterReloadEPAS service accountStarts the autovacuum subprocess.
autovacuum_analyze_scale_factorClusterReloadEPAS service accountNumber of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.
autovacuum_analyze_thresholdClusterReloadEPAS service accountMinimum number of tuple inserts, updates, or deletes prior to analyze.
autovacuum_freeze_max_ageClusterRestartEPAS service accountAge at which to autovacuum a table to prevent transaction ID wraparound.
autovacuum_max_workersClusterRestartEPAS service accountSets the maximum number of simultaneously running autovacuum worker processes.
autovacuum_multixact_freeze_max_ageClusterRestartEPAS service accountMultixact age at which to autovacuum a table to prevent multixact wraparound.
autovacuum_naptimeClusterReloadEPAS service accountTime to sleep between autovacuum runs.
autovacuum_vacuum_cost_delayClusterReloadEPAS service accountVacuum cost delay in milliseconds, for autovacuum.
autovacuum_vacuum_cost_limitClusterReloadEPAS service accountVacuum cost amount available before napping, for autovacuum.
autovacuum_vacuum_scale_factorClusterReloadEPAS service accountNumber of tuple updates or deletes prior to vacuum as a fraction of reltuples.
autovacuum_vacuum_thresholdClusterReloadEPAS service accountMinimum number of tuple updates or deletes prior to vacuum.
autovacuum_work_memClusterReloadEPAS service accountSets the maximum memory to be used by each autovacuum worker process.
backslash_quoteSessionImmediateUserSets whether "\'" is allowed in string literals.
bgwriter_delayClusterReloadEPAS service accountBackground writer sleep time between rounds.
bgwriter_lru_maxpagesClusterReloadEPAS service accountBackground writer maximum number of LRU pages to flush per round.
bgwriter_lru_multiplierClusterReloadEPAS service accountMultiple of the average buffer usage to free per round.
block_sizeClusterPresetn/aShows the size of a disk block.
bonjourClusterRestartEPAS service accountEnables advertising the server via Bonjour.
bonjour_nameClusterRestartEPAS service accountSets the Bonjour service name.
bytea_outputSessionImmediateUserSets the output format for bytea.
check_function_bodiesSessionImmediateUserCheck function bodies during CREATE FUNCTION.
checkpoint_completion_targetClusterReloadEPAS service accountTime spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.
checkpoint_segmentsDeprecatedDeprecatedDeprecatedSpecifying a value for the parameter prevents the server from starting.
checkpoint_timeoutClusterReloadEPAS service accountSets the maximum time between automatic WAL checkpoints.
checkpoint_warningClusterReloadEPAS service accountEnables warnings if checkpoint segments are filled more frequently than this.
client_encodingSessionImmediateUserSets the client's character set encoding.
client_min_messagesSessionImmediateUserSets the message levels that are sent to the client.
commit_delaySessionImmediateSuperuserSets the delay in microseconds between transaction commit and flushing WAL to disk.
commit_siblingsSessionImmediateUserSets the minimum concurrent open transactions before performing commit_delay.
config_fileClusterRestartEPAS service accountSets the server's main configuration file.
constraint_exclusionSessionImmediateUserEnables the planner to use constraints to optimize queries.
cpu_index_tuple_costSessionImmediateUserSets the planner's estimate of the cost of processing each index entry during an index scan.
cpu_operator_costSessionImmediateUserSets the planner's estimate of the cost of processing each operator or function call.
cpu_tuple_costSessionImmediateUserSets the planner's estimate of the cost of processing each tuple (row).
cursor_tuple_fractionSessionImmediateUserSets the planner's estimate of the fraction of a cursor's rows to retrieve.
custom_variable_classesClusterReloadEPAS service accountDeprecated in EDB Postgres Advanced Server 9.2.X
data_checksumsClusterPresetn/aShows whether data checksums are turned on for this cluster.
data_directoryClusterRestartEPAS service accountSets the server's data directory.
datestyleSessionImmediateUserSets the display format for date and time values.
db_dialectSessionImmediateUserSets the precedence of built-in namespaces.X
dbms_alert.max_alertsClusterRestartEPAS service accountSets maximum number of alerts.X
dbms_pipe.total_message_bufferClusterRestartEPAS service accountSpecifies the total size of the buffer used for the DBMS_PIPE package.X
db_user_namespaceClusterReloadEPAS service accountEnables per-database user names.
deadlock_timeoutSessionImmediateSuperuserSets the time to wait on a lock before checking for deadlock.
debug_assertionsClusterPresetn/aTurns on various assertion checks. (Not supported in EPAS builds.)
debug_pretty_printSessionImmediateUserIndents parse and plan tree displays.
debug_print_parseSessionImmediateUserLogs each query's parse tree.
debug_print_planSessionImmediateUserLogs each query's execution plan.
debug_print_rewrittenSessionImmediateUserLogs each query's rewritten parse tree.
default_heap_fillfactorSessionImmediateUserCreate new tables with this heap fillfactor by default.X
default_statistics_targetSessionImmediateUserSets the default statistics target.
default_tablespaceSessionImmediateUserSets the default tablespace to create tables and indexes in.
default_text_search_configSessionImmediateUserSets default text search configuration.
default_transaction_deferrableSessionImmediateUserSets the default deferrable status of new transactions.
default_transaction_isolationSessionImmediateUserSets the transaction isolation level of each new transaction.
default_transaction_read_onlySessionImmediateUserSets the default read-only status of new transactions.
default_with_oidsSessionImmediateUserCreate new tables with OIDs by default.
default_with_rowidsSessionImmediateUserCreate new tables with ROWID support (ROWIDs with indexes) by default.X
dynamic_library_pathSessionImmediateSuperuserSets the path for dynamically loadable modules.
dynamic_shared_memory_typeClusterRestartEPAS service accountSelects the dynamic shared memory implementation used.
edb_auditClusterReloadEPAS service accountEnable EDB Auditing to create audit reports in XML or CSV format.X
edb_audit_archiverClusterRestartEPAS service accountEnable audit log archiver process.X
edb_audit_archiver_timeoutClusterReloadEPAS service accountChecks the audit log files based on the edb_audit_archiver_timeout parameter.X
edb_audit_archiver_filename_prefixClusterReloadEPAS service accountDetermines audit log files with edb_audit_archiver_filename_prefix in edb_audit_directory are eligible for compression and/or expiration; the parameter must align with edb_audit_filename.X
edb_audit_archiver_compress_time_limitClusterReloadEPAS service accountShows time in seconds after which the audit logs are eligible for compression.X
edb_audit_archiver_compress_size_limitClusterReloadEPAS service accountShows total size in megabytes after which the audit logs are eligible for compression.X
edb_audit_archiver_compress_commandClusterReloadEPAS service accountThe command to compress the audit log files.X
edb_audit_archiver_compress_suffixClusterReloadEPAS service accountDetermines suffix for an already compressed log file; the parameter must align with edb_audit_archiver_compress_command.X
edb_audit_archiver_expire_time_limitClusterReloadEPAS service accountShows time in seconds after which the audit logs are eligible for expiration.X
edb_audit_archiver_expire_size_limitClusterReloadEPAS service accountShows total size in megabytes after which the audit logs are eligible for expiration.X
edb_audit_archiver_expire_commandClusterReloadEPAS service accountThe command to execute on an expired audit log before removing it.X
edb_audit_archiver_sort_fileClusterReloadEPAS service accountIdentifies the oldest log file and sort them alphabetically or based on mtime.X
edb_audit_connectClusterReloadEPAS service accountAudits each successful connection.X
edb_audit_destinationClusterReloadEPAS service accountSets 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_directoryClusterReloadEPAS service accountSets the destination directory for audit files.X
edb_audit_disconnectClusterReloadEPAS service accountAudits end of a session.X
edb_audit_filenameClusterReloadEPAS service accountSets the file name pattern for audit files.X
edb_audit_rotation_dayClusterReloadEPAS service accountAutomatic rotation of log files based on day of week.X
edb_audit_rotation_secondsClusterReloadEPAS service accountAutomatic log file rotation occurs after N seconds.X
edb_audit_rotation_sizeClusterReloadEPAS service accountAutomatic log file rotation occurs after N Megabytes.X
edb_audit_statementClusterReloadEPAS service accountSets the type of statements to audit.X
edb_audit_tagSessionImmediateUserSpecify a tag to be included in the audit log.X
edb_connectby_orderSessionImmediateUserSort results of CONNECT BY queries with no ORDER BY to depth-first order. Note: For internal use only.X
edb_custom_plan_triesSessionImmediateUserSpecifies the number of custom execution plans considered by the planner before the planner selects a generic execution plan.X
edb_data_redactionSessionImmediateUserEnable data redaction.X
edb_dynatuneClusterRestartEPAS service accountSets the edb utilization percentage.X
edb_dynatune_profileClusterRestartEPAS service accountSets the workload profile for dynatune.X
edb_enable_pruningSessionImmediateUserEnables the planner to early-prune partitioned tables.X
edb_log_every_bulk_valueSessionImmediateSuperuserSets the statements logged for bulk processing.X
edb_max_resource_groupsClusterRestartEPAS service accountSpecifies the maximum number of resource groups for simultaneous use.X
edb_max_spins_per_delayClusterRestartEPAS service accountSpecifies the number of times a session spins while waiting for a lock.X
edb_redwood_dateSessionImmediateUserDetermines whether DATE should behave like a TIMESTAMP or not.X
edb_redwood_greatest_leastSessionImmediateUserDetermines how GREATEST and LEAST functions should handle NULL parameters.X
edb_redwood_raw_namesSessionImmediateUserReturn the unmodified name stored in the PostgreSQL system catalogs from Redwood interfaces.X
edb_redwood_stringsSessionImmediateUserTreat NULL as an empty string when concatenated with a text value.X
edb_resource_groupSessionImmediateUserSpecifies the resource group to be used by the current process.X
edb_sql_protect.enabledClusterReloadEPAS service accountDefines whether SQL/Protect should track queries or not.X
edb_sql_protect.levelClusterReloadEPAS service accountDefines the behavior of SQL/Protect when an event is found.X
edb_sql_protect.max_protected_relationsClusterRestartEPAS service accountSets the maximum number of relations protected by SQL/Protect per role.X
edb_sql_protect.max_protected_rolesClusterRestartEPAS service accountSets the maximum number of roles protected by SQL/Protect.X
edb_sql_protect.max_queries_to_saveClusterRestartEPAS service accountSets the maximum number of offending queries to save by SQL/Protect.X
edb_stmt_level_txSessionImmediateUserAllows continuing on errors instead of requiring a transaction abort.X
edb_wait_states.directoryClusterRestartEPAS service accountThe EDB wait states logs are stored in this directory.X
edb_wait_states.retention_periodClusterReloadEPAS service accountEDB wait state log files are automatically deleted after retention period.X
edb_wait_states.sampling_intervalClusterReloadEPAS service accountThe interval between two EDB wait state sampling cycles.X
edbldr.empty_csv_fieldSessionImmediateSuperuserSpecifies how EDB*Loader handles empty strings.X
effective_cache_sizeSessionImmediateUserSets the planner's assumption about the size of the disk cache.
effective_io_concurrencySessionImmediateUserNumber of simultaneous requests that can be handled efficiently by the disk subsystem.
enable_bitmapscanSessionImmediateUserEnables the planner's use of bitmap-scan plans.
enable_hashaggSessionImmediateUserEnables the planner's use of hashed aggregation plans.
enable_hashjoinSessionImmediateUserEnables the planner's use of hash join plans.
enable_hintsSessionImmediateUserEnable optimizer hints in SQL statements.X
enable_indexonlyscanSessionImmediateUserEnables the planner’s use of index-only-scan plans.
enable_indexscanSessionImmediateUserEnables the planner's use of index-scan plans.
enable_materialSessionImmediateUserEnables the planner's use of materialization.
enable_mergejoinSessionImmediateUserEnables the planner's use of merge join plans.
enable_nestloopSessionImmediateUserEnables the planner's use of nested-loop join plans.
enable_seqscanSessionImmediateUserEnables the planner's use of sequential-scan plans.
enable_sortSessionImmediateUserEnables the planner's use of explicit sort steps.
enable_tidscanSessionImmediateUserEnables the planner's use of TID scan plans.
escape_string_warningSessionImmediateUserWarn about backslash escapes in ordinary string literals.
event_sourceClusterRestartEPAS service accountSets the application name used to identify PostgreSQL messages in the event log.
exit_on_errorSessionImmediateUserTerminate session on any error.
external_pid_fileClusterRestartEPAS service accountWrites the postmaster PID to the specified file.
extra_float_digitsSessionImmediateUserSets the number of digits displayed for floating-point values.
from_collapse_limitSessionImmediateUserSets the FROM-list size beyond which subqueries are not collapsed.
fsyncClusterReloadEPAS service accountForces synchronization of updates to disk.
full_page_writesClusterReloadEPAS service accountWrites full pages to WAL when first modified after a checkpoint.
geqoSessionImmediateUserEnables genetic query optimization.
geqo_effortSessionImmediateUserGEQO: effort is used to set the default for other GEQO parameters.
geqo_generationsSessionImmediateUserGEQO: number of iterations of the algorithm.
geqo_pool_sizeSessionImmediateUserGEQO: number of individuals in the population.
geqo_seedSessionImmediateUserGEQO: seed for random path selection.
geqo_selection_biasSessionImmediateUserGEQO: selective pressure within the population.
geqo_thresholdSessionImmediateUserSets the threshold of FROM items beyond which GEQO is used.
gin_fuzzy_search_limitSessionImmediateUserSets the maximum allowed result for exact search by GIN.
hba_fileClusterRestartEPAS service accountSets the server's "hba" configuration file.
hot_standbyClusterRestartEPAS service accountAllows connections and queries during recovery.
hot_standby_feedbackClusterReloadEPAS service accountAllows feedback from a hot standby to the primary that avoids query conflicts.
huge_pagesClusterRestartEPAS service accountUse of huge pages on Linux.
icu_short_formDatabasePresetn/aShows the ICU collation order configuration.X
ident_fileClusterRestartEPAS service accountSets the server's "ident" configuration file.
ignore_checksum_failureSessionImmediateSuperuserContinues processing after a checksum failure.
ignore_system_indexesCluster/SessionReload/ImmediateEPAS service account/UserDisables reading from system indexes. (Can also be set with PGOPTIONS at session start.)
index_advisor.enabledSessionImmediateUserEnable Index Advisor plugin.X
integer_datetimesClusterPresetn/aDatetimes are integer based.
intervalStyleSessionImmediateUserSets the display format for interval values.
join_collapse_limitSessionImmediateUserSets the FROM-list size beyond which JOIN constructs are not flattened.
krb_caseins_usersClusterReloadEPAS service accountSets whether Kerberos and GSSAPI user names should be treated as case-insensitive.
krb_server_keyfileClusterReloadEPAS service accountSets the location of the Kerberos server key file.
lc_collateDatabasePresetn/aShows the collation order locale.
lc_ctypeDatabasePresetn/aShows the character classification and case conversion locale.
lc_messagesSessionImmediateSuperuserSets the language in which messages are displayed.
lc_monetarySessionImmediateUserSets the locale for formatting monetary amounts.
lc_numericSessionImmediateUserSets the locale for formatting numbers.
lc_timeSessionImmediateUserSets the locale for formatting date and time values.
listen_addressesClusterRestartEPAS service accountSets the host name or IP address(es) to listen to.
local_preload_librariesCluster/SessionReload/ImmediateEPAS service account/UserLists shared libraries to preload into each backend. (Can also be set with PGOPTIONS at session start.)
lock_timeoutSessionImmediateUserSets the maximum time allowed that a statement may wait for a lock.
lo_compat_privilegesSessionImmediateSuperuserEnables backward compatibility mode for privilege checks on large objects.
log_autovacuum_min_durationClusterReloadEPAS service accountSets the minimum execution time above which autovacuum actions are logged.
log_checkpointsClusterReloadEPAS service accountLogs each checkpoint.
log_connectionsCluster/SessionReload/ImmediateEPAS service account/UserLogs each successful connection. (Can also be set with PGOPTIONS at session start.)
log_destinationClusterReloadEPAS service accountSets the destination for server log output.
log_directoryClusterReloadEPAS service accountSets the destination directory for log files.
log_disconnectionsCluster/SessionReload/ImmediateEPAS service account/UserLogs end of a session, including duration. (Can also be set with PGOPTIONS at session start.)
log_durationSessionImmediateSuperuserLogs the duration of each completed SQL statement.
log_error_verbositySessionImmediateSuperuserSets the verbosity of logged messages.
log_executor_statsSessionImmediateSuperuserWrites executor performance statistics to the server log.
log_file_modeClusterReloadEPAS service accountSets the file permissions for log files.
log_filenameClusterReloadEPAS service accountSets the file name pattern for log files.
log_hostnameClusterReloadEPAS service accountLogs the host name in the connection logs.
log_line_prefixClusterReloadEPAS service accountControls information prefixed to each log line.
log_lock_waitsSessionImmediateSuperuserLogs long lock waits.
log_min_duration_statementSessionImmediateSuperuserSets the minimum execution time above which statements are logged.
log_min_error_statementSessionImmediateSuperuserCauses all statements generating error at or above this level to be logged.
log_min_messagesSessionImmediateSuperuserSets the message levels that are logged.
log_parser_statsSessionImmediateSuperuserWrites parser performance statistics to the server log.
log_planner_statsSessionImmediateSuperuserWrites planner performance statistics to the server log.
log_rotation_ageClusterReloadEPAS service accountAutomatic log file rotation occurs after N minutes.
log_rotation_sizeClusterReloadEPAS service accountAutomatic log file rotation occurs after N kilobytes.
log_statementSessionImmediateSuperuserSets the type of statements logged.
log_statement_statsSessionImmediateSuperuserWrites cumulative performance statistics to the server log.
log_temp_filesSessionImmediateSuperuserLog the use of temporary files larger than this number of kilobytes.
log_timezoneClusterReloadEPAS service accountSets the time zone to use in log messages.
log_truncate_on_rotationClusterReloadEPAS service accountTruncate existing log files of same name during log rotation.
logging_collectorClusterRestartEPAS service accountStart a subprocess to capture stderr output and/or csv logs into log files.
maintenance_work_memSessionImmediateUserSets the maximum memory to be used for maintenance operations.
max_connectionsClusterRestartEPAS service accountSets the maximum number of concurrent connections.
max_files_per_processClusterRestartEPAS service accountSets the maximum number of simultaneously open files for each server process.
max_function_argsClusterPresetn/aShows the maximum number of function arguments.
max_identifier_lengthClusterPresetn/aShows the maximum identifier length.
max_index_keysClusterPresetn/aShows the maximum number of index keys.
max_locks_per_transactionClusterRestartEPAS service accountSets the maximum number of locks per transaction.
max_pred_locks_per_transactionClusterRestartEPAS service accountSets the maximum number of predicate locks per transaction.
max_prepared_transactionsClusterRestartEPAS service accountSets the maximum number of simultaneously prepared transactions.
max_replication_slotsClusterRestartEPAS service accountSets the maximum number of simultaneously defined replication slots.
max_stack_depthSessionImmediateSuperuserSets the maximum stack depth, in kilobytes.
max_standby_archive_delayClusterReloadEPAS service accountSets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.
max_standby_streaming_delayClusterReloadEPAS service accountSets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.
max_wal_sendersClusterRestartEPAS service accountSets the maximum number of simultaneously running WAL sender processes.
max_wal_sizeClusterReloadEPAS service accountSets the maximum size to which the WAL grows between automatic WAL checkpoints. The default is 1GB.
max_worker_processesClusterRestartEPAS service accountMaximum number of concurrent worker processes.
min_wal_sizeClusterReloadEPAS service accountSets the threshold at which WAL logs is recycled rather than removed. The default is 80 MB.
nls_length_semanticsSessionImmediateSuperuserSets the semantics to use for char, varchar, varchar2 and long columns.X
odbc_lib_pathClusterRestartEPAS service accountSets the path for ODBC library.X
optimizer_modeSessionImmediateUserDefault optimizer mode.X
oracle_homeClusterRestartEPAS service accountSets the path for the Oracle home directory.X
password_encryptionSessionImmediateUserEncrypt passwords.
pg_prewarm.autoprewarmClusterRestartEPAS service accountEnables the autoprewarm background worker.X
pg_prewarm.autoprewarm_intervalClusterReloadEPAS service accountSets the minimum number of seconds after which autoprewarm dumps shared buffers.X
portClusterRestartEPAS service accountSets the TCP port on which the server listens.
post_auth_delayCluster/SessionReload/ImmediateEPAS service account/UserWaits N seconds on connection startup after authentication. (Can also be set with PGOPTIONS at session start.)
pre_auth_delayClusterReloadEPAS service accountWaits N seconds on connection startup before authentication.
qreplace_functionSessionImmediateSuperuserThe function to be used by Query Replace feature. Note: For internal use only.X
query_rewrite_enabledSessionImmediateUserChild table scans are skipped if their constraints guarantee that no rows match the query.X
query_rewrite_integritySessionImmediateSuperuserSets the degree to which query rewriting must be enforced.X
quote_all_identifiersSessionImmediateUserWhen generating SQL fragments, quote all identifiers.
random_page_costSessionImmediateUserSets the planner's estimate of the cost of a nonsequentially fetched disk page.
restart_after_crashClusterReloadEPAS service accountReinitialize server after backend crash.
search_pathSessionImmediateUserSets the schema search order for names that are not schema-qualified.
segment_sizeClusterPresetn/aShows the number of pages per disk file.
seq_page_costSessionImmediateUserSets the planner's estimate of the cost of a sequentially fetched disk page.
server_encodingDatabasePresetn/aSets the server (database) character set encoding.
server_versionClusterPresetn/aShows the server version.
server_version_numClusterPresetn/aShows the server version as an integer.
session_preload_librariesSessionImmediate but only at connection startSuperuserLists shared libraries to preload into each backend.
session_replication_roleSessionImmediateSuperuserSets the session's behavior for triggers and rewrite rules.
shared_buffersClusterRestartEPAS service accountSets the number of shared memory buffers used by the server.
shared_preload_librariesClusterRestartEPAS service accountLists shared libraries to preload into server.
sql_inheritanceSessionImmediateUserCauses subtables to be included by default in various commands.
sslClusterRestartEPAS service accountEnables SSL connections.
ssl_ca_fileClusterRestartEPAS service accountLocation of the SSL certificate authority file.
ssl_cert_fileClusterRestartEPAS service accountLocation of the SSL server certificate file.
ssl_ciphersClusterRestartEPAS service accountSets the list of allowed SSL ciphers.
ssl_crl_fileClusterRestartEPAS service accountLocation of the SSL certificate revocation list file.
ssl_ecdh_curveClusterRestartEPAS service accountSets the curve to use for ECDH.
ssl_key_fileClusterRestartEPAS service accountLocation of the SSL server private key file.
ssl_prefer_server_ciphersClusterRestartEPAS service accountGive priority to server ciphersuite order.
ssl_renegotiation_limitSessionImmediateUserSet the amount of traffic to send and receive before renegotiating the encryption keys.
standard_conforming_stringsSessionImmediateUserCauses '...' strings to treat backslashes literally.
statement_timeoutSessionImmediateUserSets the maximum allowed duration of any statement.
stats_temp_directoryClusterReloadEPAS service accountWrites temporary statistics files to the specified directory.
superuser_reserved_connectionsClusterRestartEPAS service accountSets the number of connection slots reserved for superusers.
synchronize_seqscansSessionImmediateUserEnable synchronized sequential scans.
synchronous_commitSessionImmediateUserSets immediate fsync at commit.
synchronous_standby_namesClusterReloadEPAS service accountList of names of potential synchronous standbys.
syslog_facilityClusterReloadEPAS service accountSets the syslog "facility" to be used when syslog enabled.
syslog_identClusterReloadEPAS service accountSets the program name used to identify PostgreSQL messages in syslog.
tcp_keepalives_countSessionImmediateUserMaximum number of TCP keepalive retransmits.
tcp_keepalives_idleSessionImmediateUserTime between issuing TCP keepalives.
tcp_keepalives_intervalSessionImmediateUserTime between TCP keepalive retransmits.
temp_buffersSessionImmediateUserSets the maximum number of temporary buffers used by each session.
temp_file_limitSessionImmediateSuperuserLimits the total size of all temporary files used by each session.
temp_tablespacesSessionImmediateUserSets the tablespace(s) to use for temporary tables and sort files.
timed_statisticsSessionImmediateUserEnables the recording of timed statistics.X
timezoneSessionImmediateUserSets the time zone for displaying and interpreting time stamps.
timezone_abbreviationsSessionImmediateUserSelects a file of time zone abbreviations.
trace_hintsSessionImmediateUserEmit debug info about hints being honored.X
trace_notifySessionImmediateUserGenerates debugging output for LISTEN and NOTIFY.
trace_recovery_messagesClusterReloadEPAS service accountEnables logging of recovery-related debugging information.
trace_sortSessionImmediateUserEmit information about resource usage in sorting.
track_activitiesSessionImmediateSuperuserCollects information about executing commands.
track_activity_query_sizeClusterRestartEPAS service accountSets the size reserved for pg_stat_activity.current_query, in bytes.
track_countsSessionImmediateSuperuserCollects statistics on database activity.
track_functionsSessionImmediateSuperuserCollects function-level statistics on database activity.
track_io_timingSessionImmediateSuperuserCollects timing statistics for database I/O activity.
transaction_deferrableSessionImmediateUserWhether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.
transaction_isolationSessionImmediateUserSets the current transaction's isolation level.
transaction_read_onlySessionImmediateUserSets the current transaction's read-only status.
transform_null_equalsSessionImmediateUserTreats "expr=NULL" as "expr IS NULL".
unix_socket_directoriesClusterRestartEPAS service accountSets the directory where the Unix-domain socket is created.
unix_socket_groupClusterRestartEPAS service accountSets the owning group of the Unix-domain socket.
unix_socket_permissionsClusterRestartEPAS service accountSets the access permissions of the Unix-domain socket.
update_process_titleSessionImmediateSuperuserUpdates the process title to show the active SQL command.
utl_encode.uudecode_redwoodSessionImmediateUserAllows decoding of Oracle-created uuencoded data.X
utl_file.umaskSessionImmediateUserUmask used for files created through the UTL_FILE package.X
vacuum_cost_delaySessionImmediateUserVacuum cost delay in milliseconds.
vacuum_cost_limitSessionImmediateUserVacuum cost amount available before napping.
vacuum_cost_page_dirtySessionImmediateUserVacuum cost for a page dirtied by vacuum.
vacuum_cost_page_hitSessionImmediateUserVacuum cost for a page found in the buffer cache.
vacuum_cost_page_missSessionImmediateUserVacuum cost for a page not found in the buffer cache.
vacuum_defer_cleanup_ageClusterReloadEPAS service accountNumber of transactions by which VACUUM and HOT cleanup should be deferred, if any.
vacuum_freeze_min_ageSessionImmediateUserMinimum age at which VACUUM should freeze a table row.
vacuum_freeze_table_ageSessionImmediateUserAge at which VACUUM should scan whole table to freeze tuples.
vacuum_multixact_freeze_min_ageSessionImmediateUserMinimum age at which VACUUM should freeze a MultiXactId in a table row.
vacuum_multixact_freeze_table_ageSessionImmediateUserMultixact age at which VACUUM should scan whole table to freeze tuples.
wal_block_sizeClusterPresetn/aShows the block size in the write ahead log.
wal_buffersClusterRestartEPAS service accountSets the number of disk-page buffers in shared memory for WAL.
wal_keep_segmentsClusterReloadEPAS service accountSets the number of WAL files held for standby servers.
wal_levelClusterRestartEPAS service accountSet the level of information written to the WAL.
wal_log_hintsClusterRestartEPAS service accountWrites full pages to WAL when first modified after a checkpoint, even for non-critical modifications.
wal_receiver_status_intervalClusterReloadEPAS service accountSets the maximum interval between WAL receiver status reports to the primary.
wal_receiver_timeoutClusterReloadEPAS service accountSets the maximum wait time to receive data from the primary.
wal_segment_sizeClusterPresetn/aShows the number of pages per write ahead log segment.
wal_sender_timeoutClusterReloadEPAS service accountSets the maximum time to wait for WAL replication.
wal_sync_methodClusterReloadEPAS service accountSelects the method used for forcing WAL updates to disk.
wal_writer_delayClusterReloadEPAS service accountWAL writer sleep time between WAL flushes.
work_memSessionImmediateUserSets the maximum memory to be used for query workspaces.
xloginsert_locksClusterRestartEPAS service accountSets the number of locks used for concurrent xlog insertions.
xmlbinarySessionImmediateUserSets how binary values are to be encoded in XML.
xmloptionSessionImmediateUserSets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.
zero_damaged_pagesSessionImmediateSuperuserContinues processing past damaged page headers.