Configuration parameters by functionality v14

This section provides more detail for certain groups of configuration parameters.

The section heading for each parameter is followed by a list of attributes:

  • Parameter ype. Type of values the parameter can accept. See Setting configuration parameters section for a discussion of parameter type values.
  • Default Value. Default setting if a value is not explicitly set in the configuration file.
  • Range. Permitted range of values.
  • Minimum scope of effect. Smallest scope for which a distinct setting can be made. Generally, the minimal scope of a distinct setting is either the entire cluster (the setting is the same for all databases and sessions thereof, in the cluster), or per session (the setting may vary by role, database, or individual session). (This attribute has the same meaning as the Scope of Effect column in the table of Summary of Configuration Parameters).
  • When Value Changes Take Effect. Least invasive action required to activate a change to a parameter’s value. All parameter setting changes made in the configuration file can be put into effect with a restart of the database server; however certain parameters require a database server restart. Some parameter setting changes can be put into effect with a reload of the configuration file without stopping the database server. Finally, other parameter setting changes can be put into effect with some client side action whose result is immediate. (This attribute has the same meaning as the When Takes Effect column in the table of Summary of Configuration Parameters).
  • Required Authorization to Activate. The type of user authorization to activate a change to a parameter’s setting. If a database server restart or a configuration file reload is required, then the user must be a EPAS service account (enterprisedb or postgres depending upon the EDB Postgres Advanced Server compatibility installation mode). (This attribute has the same meaning as the Authorized User column in the table of Summary of Configuration Parameters).

top_performance_related_parameters resource_usage_memory resource_usage_edb_resource_manager query_tuning query_tuning_planner_method_configuration reporting_and_logging_what_to_log auditing_settings ccd_locale_and_formatting ccd_statement_behaviour ccd_other_defaults compatibility_options customized_options ungrouped audit_archiver