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.



      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 


Leave a Comment

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