REBALANCE_TABLE

Synchronously rebalances data in the specified table.

A rebalance operation performs the following tasks:

Syntax

REBALANCE_TABLE('[schema.]table‑name')

Parameters

schema

Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example:

myschema.thisDbObject
table‑name

The table to rebalance.

Privileges

Superuser

When to Rebalance

Rebalancing is useful or even necessary after you perform the following tasks:

Tip: By default, before performing a rebalance, Vertica queries system tables to compute the size of all projections involved in the rebalance task. This query can add significant overhead to the rebalance operation. To disable this query, set projection configuration parameter RebalanceQueryStorageContainers to 0.

Example

The following command shows how to rebalance data on the specified table.

=> SELECT REBALANCE_TABLE('online_sales.online_sales_fact'); 
REBALANCE_TABLE 
-------------------
 REBALANCED
(1 row)