Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica Performance troubleshooting

We just got a new cluster, which is much better hardware spec than current one. but when we run the performance test, on the same job, a new one was slower than old one.
Has any document or troubleshooting tips on this kind of issues?


Best Answer


  • You can look at the explain ,then confirm resource pool and execute a few more times to compare

  • I narrowed down the issue, even I did simple sql it was much slower than old one.
    sql like: select date,count(*) from table group by date;
    any configuration I need to check?

  • Hi,
    You comment is that the new hardware spec is better, but how is it better? Are you sure the hardware is configured to run optimally for low latency? If you can provide some more information on the new hardware, it would be helpful.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.