Upgrade 6.0 to 7.1 - database is slower
Posted: Fri Feb 05, 2016 3:25 pm
We recently upgraded our DEV vertica database from 6.0 to 7.1. After some trial and error and some help from HP Vertica, we followed all the upgrade steps from 6.0 to 6.1, 6.1 to 7.0 and 7.0 to 7.1. We also applied the latest hotfix. However, in testing our production processing against our DEV environment, the processing times are significantly slower, almost double the timings. We actually have one process that updates about 8 million records that will not run at all. Has anyone else experienced this issue? Or have any idea of where to start looking for the cause?
Your help is much appreciated!!
Your help is much appreciated!!