Re: vacuum is time consuming

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