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

Superuser

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