DISABLE_ELASTIC_CLUSTER

Disables elastic cluster scaling, which prevents Vertica from bundling data into chunks that are easily transportable to other nodes when performing cluster resizing. The main reason to disable elastic clustering is if you find that the slightly unequal data distribution in your cluster caused by grouping data into discrete blocks results in performance issues.

Syntax

DISABLE_ELASTIC_CLUSTER()

Privileges

Superuser

Example

=> SELECT DISABLE_ELASTIC_CLUSTER();
 DISABLE_ELASTIC_CLUSTER 
-------------------------
 DISABLED
(1 row)