Skip to main content

Vertica Back up and Restore affects the performance

  • March 7, 2016
  • 1 reply
  • 9 views
enigmaTix

After restoring vertica on a  new node, the queries are taking longer time then expected. After taking back up only IP addresses were changed. Earlier it used to work fine.

    1 reply

    Adrian_Oprea_1
    Forum|alt.badge.img+1
    • Adrian_Oprea_1
    • Participating Frequently
    • March 7, 2016

     

      Are all your projections with statistics ?

    select * from projections where has_statistics='false';

     And make sure you run statistics on the missing ones or full stats with 

    SELECT ANALYZE_HISTOGRAM('', 100);
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement