Rebalancing data using SQL functions

Vertica has three SQL functions for starting and stopping a cluster rebalance. You can call these functions from a script that runs during off-peak hours, rather than manually trigger a rebalance through Administration Tools.

• REBALANCE_CLUSTER rebalances the database cluster synchronously as a session foreground task.

• START_REBALANCE_CLUSTERasynchronously rebalances the database cluster as a background task.

• CANCEL_REBALANCE_CLUSTERstops any rebalance task that is currently in progress or is waiting to execute.