Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Cluster Management

How can we know that which node in the cluster is giving better performance?

Comments

  • All the nodes should have the same configuration, so all of them should have the same performance. If this is not the case, probably 
    1- You have the data skewed ( you can check projection_storage table to see that)
    2- You are not using a load balancer and all your queries go to same initiator ( you can check query_profiles and check the node_name column and see if the data is distributed)
    Hope this helps, 
    Eugenia

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.