Vertica Back up and Restore affects the performance

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.

Adrian_Oprea_1

 

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