[GENERAL] Why autvacuum is not started? - Mailing list pgsql-general
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
--
pgsql-general by date: