Hash segmentation
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
0
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
Comments
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
Thanks Sruthi.
Can you plz make me understand , Whats the difference between High availability and Load balancing with a practical example.