One of our customers found that more than ONE CPU socket in AWS results in performance degradation probably because of NUMA issues.
For example:
c4.8xl cost twice but works ~2-3 times slower than c4.4xl for any concurrency scenarios.
c5.9XL - (36 cores 72 GB ram) works fast with only one CPU socket.
Although not available in the Vertica AMI yet, it is fast in high concurrency scenarios.
What do you think about the above?
Do you have an environment with Vertica v8.1.1-5 to test if ONE CPU socket give better results than TWO CPU sockets on bar-metal nodes on-prem?
Thanks!
