I have running Postgresql 9.4 and... if i have a table with following configuration: autovacuum_vacuum_scale_factor=0.0, autovacuum_analyze_scale_factor=0.0, autovacuum_vacuum_threshold=1000, autovacuum_analyze_threshold=1000, autovacuum_enabled=true
Why autovacuum is not started if the table has more than 1000 inserts??? first i have setted autovacuum_vacuum_threshold to 10,000 inserts (it is normal each 2 hours ), then to 5,000, 3,000 and finally to 1,000 but autovacuum is not triggered but autoanalyze. "select relname,last_vacuum, last_autovacuum, last_analyze, last_autoanalyze from pg_stat_user_tables where relname like 'sta%';" last_vacuum=>2017-01-05 10:40:34.228633-06 last_autovacuum => null last_analyze=> 2017-01-04 15:02:47.438715-06 last_autoanalyze=> 2017-01-09 10:35:51.391114-06 --