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

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.