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
