Data Repository Vertica DB is slow to start
search cancel

Data Repository Vertica DB is slow to start


Article ID: 145860


Updated On:


CA Infrastructure Management CA Performance Management - Usage and Administration DX NetOps


I would like to understand what the Vertica DB is slow to start when you start it up again after you've properly shutdown the vertica db.  In my case, it was shut down for Linux patching, system rebooted, then I go back in to start it again. 
It will eventually start but it seems to take a long time. 


Release : 3.7

Component : IM Reporting / Admin / Configuration


Vertica needs to read in a lot of data even when the database is properly shut down. Start times of 5-10 minutes are common.  The log below shows how much time it is taking in each phase of start up.