Vertica Performance troubleshooting

davdsdavds Vertica Customer

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


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

  • 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