Re: Are my autovacuum settings too aggressive for this table?

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