The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Data & Catalog in separate disk will improve the performance ?

Hi Team,

 

If we install vertica with data & catalog in different disk , will that improve the performance ?

 

Please share some link or details which should contains

 

  1. What should be the size of catalog for best performance ?
  2. Whether Data & Catalog should be in diffenent disk ?
  3. What should be the disk space ratio between data & catalog ?

 

 

Regards.

Deb

Comments

  •   It will improve IO at the SO level, the catalog is in constant change, logs and data collector will require a high amount of IO(it makes sense ot separe them from the data store disks).

      Also look into storage tiers, it makes sense to map those if you have different types of storage for your "hot" objects. 

      Temp area should be set on a different disk.

     So yes is good to isolate yor catalog , temp area, storage tiers(based on access patterns).

     

      Disk size for the Catalog depends on your object number, logs size(cleaing), data collector configuration/retention, UDP`s , UDF`s.

      You might have a huge database with a small catalog.

     

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.