Vertica Performance troubleshooting

davdsdavds Vertica Customer

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

  • qinchaofengqinchaofeng Vertica Customer

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

  • davdsdavds Vertica Customer

    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