John Scalia wrote: > Hi all, > > The autovacuum settings for a 9.4.2 database are shown below, I'm not > absolutely certain if I missed anything: > > autovacuum = on > log_autovacuum_min_duration = 100 > autovacuum_max_workers = 15 > autovacuum_naptime = 10min > #autovacuum_vacuum_threshold = 50 > autovacuum_analyze_threshold = 80 > autovacuum_vacuum_scale_factor = 0.1 > autovacuum_analyze_scale_factor = 0.2 > autovacuum_freeze_max_age = 100000000 > autovacuum_vacuum_cost_delay = 20ms > autovacuum_vacuum_cost_limit = -1
What's the vacuum_cost_limit setting? Maybe they are sleeping for too long, and don't have time to get to some of the other tables because all 15 workers are busy. This gets worse the more workers there are.
I don't think the 10min naptime is doing you any favors, is it?
If you want them to go faster, maybe you need to lower the cost_delay. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
