The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Vertica Back up and Restore affects the performance

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.

Comments

  •  

      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);

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.