Summary of configuration parameters v14
This summary table list 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 in which the latter settings in this list override prior ones:
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 can't be changed.Restart
. You must restart the database server.Reload
. You must reload configuration file or restart the database server.Immediate
. Immediately effective in a session if thePGOPTIONS
environment variable or theSET
command is used to change the setting in the current session. Effective in new sessions ifALTER DATABASE
,ALTER ROLE
, orALTER 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, that is, the database or role to alter with theALTER
command.n/a
– No user can change the aarameter setting.
Description. Brief description of the configuration parameter.
EPAS only. Configuration parameter appllies to EDB Postgres Advanced Server only. No entry in this column indicates the configuration parameter applies to PostgreSQL as well.
Note
A number of parameters can never be altered. These are designated as Note: For internal use only in the Description column.
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 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 | Enables 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 | Checks 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 | Specifies a value for the parameter prevents 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 to retrieve. | |
custom_variable_classes | Cluster | Reload | EPAS service account | Deprecated in EDB Postgres 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 | Creates new tables with this heap fill factor 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 | Creates new tables with OIDs by default. | |
default_with_rowids | Session | Immediate | User | Creates 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 | Enables EDB Auditing to create audit reports in XML or CSV format. | X |
edb_audit_archiver | Cluster | Restart | EPAS service account | Enables audit log archiver process. | X |
edb_audit_archiver_timeout | Cluster | Reload | EPAS service account | Checks the audit log files based on the edb_audit_archiver_timeout parameter. | X |
edb_audit_archiver_filename_prefix | Cluster | Reload | EPAS service account | Determines 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_limit | Cluster | Reload | EPAS service account | Shows time in seconds after which the audit logs are eligible for compression. | X |
edb_audit_archiver_compress_size_limit | Cluster | Reload | EPAS service account | Shows total size in megabytes after which the audit logs are eligible for compression. | X |
edb_audit_archiver_compress_command | Cluster | Reload | EPAS service account | Compresses the audit log files. | X |
edb_audit_archiver_compress_suffix | Cluster | Reload | EPAS service account | Determines suffix for an already compressed log file. The parameter must align with edb_audit_archiver_compress_command . | X |
edb_audit_archiver_expire_time_limit | Cluster | Reload | EPAS service account | Shows time in seconds after which the audit logs are eligible for expiration. | X |
edb_audit_archiver_expire_size_limit | Cluster | Reload | EPAS service account | Shows total size in megabytes after which the audit logs are eligible for expiration. | X |
edb_audit_archiver_expire_command | Cluster | Reload | EPAS service account | Execute on an expired audit log before removing it. | X |
edb_audit_archiver_sort_file | Cluster | Reload | EPAS service account | Identifies the oldest log file and sorts them alphabetically or based on mtime . | 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 occurs after N seconds. | X |
edb_audit_rotation_size | Cluster | Reload | EPAS service account | Automatic log file rotation occurs 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 | Specifies a tag to include in the audit log. | X |
edb_connectby_order | Session | Immediate | User | Sorts results of CONNECT BY queries with no ORDER BY to depth-first order. Note: For internal use only. | X |
edb_data_redaction | Session | Immediate | User | Enables 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 spins 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 | Returns the unmodified name stored in the PostgreSQL system catalogs from Redwood interfaces. | X |
edb_redwood_strings | Session | Immediate | User | Treats 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 | Stores the EDB wait states logs in this directory. | X |
edb_wait_states.retention_period | Cluster | Reload | EPAS service account | Deletes EDB wait state log files 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 | Enables 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 | Warns 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 | Terminates 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 avoids query conflicts. | |
huge_pages | Cluster | Restart | EPAS service account | Uses 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 | Enables 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 are 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 are 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 occurs after N minutes. | |
log_rotation_size | Cluster | Reload | EPAS service account | Automatic log file rotation occurs 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 | Logs 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 | Truncates existing log files of same name during log rotation. | |
logging_collector | Cluster | Restart | EPAS service account | Starts 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 grows 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 is 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 | Encrypts 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 | Skils dhild table scans 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, quotes 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 | Reinitializes 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 | Gives priority to server ciphersuite order. | |
ssl_renegotiation_limit | Session | Immediate | User | Sets 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 | Enables synchronized sequential scans. | |
synchronous_commit | Session | Immediate | User | Sets immediate fsync at commit. | |
synchronous_standby_names | Cluster | Reload | EPAS service account | Lists 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 | Emits 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 | Emits information about resource usage in sorting. | |
track_activities | Session | Immediate | Superuser | Collects information about executing commands. | |
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 | Specifies 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 is 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. |