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.