Hi Atul, > 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. Just wanted to mention that maintenance_work_mem has a hardcoded upper limit threshold of 1GB, so any size bigger than that to maintenance_work_mem or autovacuum_maintenance_work_mem will leave it effectively at 1GB. There have been a few attempts the past few years on lifting that restriction. > 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. Yes, upgrade to PG13. Kind regards, Martin, -- Martín Marqués It’s not that I have something to hide, it’s that I have nothing I want you to see
