The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.
How to rebalance tables after new storage location was added to each of existing nodes?
What's the best way (must be safe and hopefully reasonably fast) to rebalance existing tables given that:
- there are 20+ nodes connected with 2x10GbE
- each node initially had 2 10TB DATA,TEMP storage locations which are now very full
- each node just had 3rd 10TB DATA,TEMP storage locations added which is basically empty
- some projections are very large (>400GB/node)
Number of nodes didn't change and isn't expected to change soon.
Any suggestions on how to do it optimally would be appreciated.