SET_CONTROL_SET_SIZE
Specifies the number of cluster nodes on which to deploy control messaging (spread). You can call this function only on a running database.
To determine whether the current spread hosts and the control designations in the catalog match, query system table LARGE_CLUSTER_CONFIGURATION_STATUS
This function is equivalent to:
install_vertica --large cluster integer
For details, see Installing a Large Cluster in the Administrator's Guide.
Syntax
SET_CONTROL_SET_SIZE( integer )
Parameters
integer |
The number of cluster hosts from the database cluster on which spread runs. |
Privileges
Example
Run spread on two cluster nodes:
=> SELECT set_control_set_size(2); SET_CONTROL_SET_SIZE ---------------------- Control size set (1 row)
See Also
Defining and Realigning Control Nodes on an Existing Cluster