The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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.