Configuration Parameters by Functionality v10
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 Type.
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 entirecluster
(the setting is the same for all databases and sessions thereof, in the cluster), orper session
(the setting may vary by role, database, or individual session). (This attribute has the same meaning as theScope 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 serverrestart
. Some parameter setting changes can be put into effect with areload
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 isimmediate
. (This attribute has the same meaning as theWhen 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
orpostgres
depending upon the Advanced Server compatibility installation mode). (This attribute has the same meaning as theAuthorized 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