Nodes with Different CPU's - Adjusting the load
I have a 4 node configuration and have a range of CPU specs for the nodes. I believe that Vertica is treating each node the same and distributing the load not based on performance. - 2 Nodes have the same CPU Specs and are the strongest in the bunch. They hardly ever work at full capacity and usually finish much faster than the other nodes and just wait until the other nodes are finished. - The other 2 Nodes have similar CPU specs, but are not identical. - I get almost the same results running the same script on all 4 Nodes as I do when I run it on 2 (using the first 2 strongest nodes) - Is there a way to optimize the setup where the load will be configured and dispersed based on Hardware Performance?