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

Vertica Performance troubleshooting

Hi,
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?

thanks
David

Best Answer

Answers

  • 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?
    thanks
    David

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.