Irene Yeh wrote:
> Ok. Did my stop and restart completely restart the auto vacuum job?
Yes. Every interruption will further delay it.
You should reduce "autovacuum_vacuum_cost_delay" to at most 2ms and
raise "maintenance_work_mem", both will speed up autovacuum.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com