The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Cluster Management

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

Comments

  • [Deleted User][Deleted User] ✭
    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...