Hash segmentation

deb0687

Hi,

 

While creating projection we do segmented by hash (col1,col2).

 

What is the rule for taking which columns and how many columns  for better performance ?

 

Can I take all the columns or only the primary key column ?

 

Regards,

Deb

SruthiA

HI,

 

 

        In a projection, the data to be hashed consists of one or more column values, Choose columns that have a large number of unique data values and acceptable skew in their data distribution. Primary key columns that meet the criteria could be an excellent choice for hash segmentation. For more information on Hash Segmentationm Please visit the link

 

http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/ConfiguringTheDB/PhysicalSchema/DesigningForSegmentation.htm?Highlight=hash segmentation

 

 

-Regards,

 Sruthi

deb0687

Thanks Sruthi.

 

Can you plz make me understand , Whats the difference between High availability and Load balancing with a practical example.