We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Increase data and catalog space with add_location option — Vertica Forum

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