Skip to main content

How to improve Rebalance_cluster() performance

  • June 11, 2017
  • 3 replies
  • 12 views

RaghavA
Forum|alt.badge.img

Hi All,

During our Vertica cluster expansion, we see that the Rebalance_cluster() operation takes un-calculated time and i guess, you might also have experienced the same.

Is there any method or temporary settings in vertica to improve rebalance operation ?

In my setup, we have a 3-node cluster and trying to add 1 more cluster. There are segmented projection where small projections was very quickly rebalanced but big projections are problematic.

when i try to rebalance a projection of 400GB, it is giving us speed of 20% seperation_percentage per hour and overall task takes about 6 hours. Any method to pump-up this operation to save time?

Regards,
Raghav Agrawal

3 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 13, 2017

Check out the Knowledge Base post "Best Practices for Preparing Your Cluster for Rebalance". It's packed with a lot of great recommendations!

https://my.vertica.com/kb/PrepareYourClusterforRebalance/Content/BestPractices/PrepareYourClusterforRebalance.htm


Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • June 13, 2017

Check out the Knowledge Base post "Best Practices for Preparing Your Cluster for Rebalance". It's packed full of great recommendations!

https://my.vertica.com/kb/PrepareYourClusterforRebalance/Content/BestPractices/PrepareYourClusterforRebalance.htm


RaghavA
Forum|alt.badge.img
  • Author
  • Participating Frequently
  • June 14, 2017

Hi Emoreno,

we are using v7.0.x. i will go thru the BestPractises document.

Regards,
RaghavA