We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Cluster Management — Vertica Forum
Options

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 ...