Increase data and catalog space with add_location option

We have a vertica setup whose diskspace requiremnt can go upto 1 TB over time.  But we want to strat with 200G and add new data and catalog locations as needed later using add_location option.  

 

I have below question:

 

1. Is expanding databased using add_location is the recommaneded appraoch ?  Are there any alternatives to expand disk space availablity. 

 

2. Does adding more location have any impact on perfroamcne ? 1 Big TB location Vs 5 relatively samll  200G locations - Will there be any varience in perfromacne.

For us all locations are similar from perfromacne (No storage hierarchy). 

 

Thanks

-Siva

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file