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

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


  • 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, 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file