SET and RESET

SET GLOBAL can be used to change a global cluster setting, see Cluster-wide settings, to a different value. Using will reset the cluster setting to its default value or to the setting value defined in the configuration file, if it was set on a node start-up. The global cluster settings can be applied to a cluster using PERSISTENT and TRANSIENT keywords to set a persistent level.

SET/SET SESSION may affect the current session if the setting is supported. Setting the unsupported settings will be ignored and logged with the WARN logging level. See , to get an overview of the supported session setting parameters.

SET LOCAL does not have any effect on CrateDB configurations. All statements will be ignored by CrateDB and logged with the WARN logging level.

SET SESSION/LOCAL are introduced to be compliant with third-party applications which use the PostgresSQL wire protocol.

setting_ident

value

The value to set for the setting.

ident

The ident to set for the setting.

setting_value

DEFAULT

Used for resetting the parameter to its default value.

The default is TRANSIENT. Settings that are set using the TRANSIENT keyword will be discarded if the cluster is stopped or restarted.

Using the PERSISTENT keyword will persist a value of the setting to a disk, so that the setting will not be discarded if the cluster restarts.

Note