On Fri, 2019-11-01 at 18:58 +0000, Jason Ralph wrote:
> autovacuum_naptime = 1h
> autovacuum_vacuum_threshold = 10000
> autovacuum_analyze_threshold = 5000
> autovacuum_vacuum_scale_factor = 0.002
> autovacuum_analyze_scale_factor = 0.001
These seem to be crazy settings.
Only once an hour you test if a table needs autovacuum, and then you
configure autovacuum to process tables all the time.
There are only three autovacuum workers, so most of the tables won't
get vacuumed.
Please reset all these values to their default.
If you want autovacuum to be more aggressive for a single table, run
ALTER TABLE x SET (autovacuum_vacuum_cost_delay = 2);
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
