Before performing a rebalance, Vertica by default will query 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 the configuration parameter RebalanceQueryStorageContainers to 0.
Example:
dbadmin=> SELECT DISTINCT parameter_name, current_value, default_value, description
dbadmin-> FROM vs_configuration_parameters
dbadmin-> WHERE parameter_name = 'RebalanceQueryStorageContainers';
parameter_name | current_value | default_value | description
---------------------------------+---------------+---------------+----------------------------------------
RebalanceQueryStorageContainers | 1 | 1 | Check storage containers for rebalance
(1 row)
dbadmin=> ALTER DATABASE wwt SET RebalanceQueryStorageContainers = 0;
ALTER DATABASE
dbadmin=> SELECT DISTINCT parameter_name, current_value, default_value, description
dbadmin-> FROM vs_configuration_parameters
dbadmin-> WHERE parameter_name = 'RebalanceQueryStorageContainers';
parameter_name | current_value | default_value | description
---------------------------------+---------------+---------------+----------------------------------------
RebalanceQueryStorageContainers | 0 | 1 | Check storage containers for rebalance
(1 row)
Have Fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
