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 ?
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
Can you plz make me understand , Whats the difference between High availability and Load balancing with a practical example.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.