Hi, We have DB of 400GBs, Server RAM is 160GBs. CPU consumption is 1-3% only.
We have configured maintenance_work_mem to 10GBs and restarted the postgres service. We have done upgrade from postgres 9.5 to 9.6, then when we run vacuum analyze on database, it is taking more than 5 hours and still running. Any suggestions for making the process(vacuum analyze) faster are welcome.
