unexplained autovacuum to prevent wraparound
От | Gordon Shannon |
---|---|
Тема | unexplained autovacuum to prevent wraparound |
Дата | |
Msg-id | 27883825.post@talk.nabble.com обсуждение исходный текст |
Список | pgsql-general |
It appears to me that in my 8.4.0 system, autovacuum is running to prevent wraparound contrary to the documentation. I have it set to a tables' relfrozenxid has to get to 1.5 billion before that kicks in: > show autovacuum_freeze_max_age; 1500000000 > show vacuum_freeze_table_age; 1300000000 > show vacuum_freeze_min_age; 1000000000 Table foo has an age just over 1 billion, still well under the freeze_table_age: > select age(relfrozenxid) from pg_class where relname='foo'; age ------------ 1055823634 yet, I see this in pg_stat_activity: autovacuum: VACUUM public.foo (to prevent wraparound) One possibly interesting thing is that this seems to have started just after I set foo's autovacuum_analyze_scale_factor to 0.01, since I wanted more frequent analyze runs. I wonder if that could be related. Any ideas? These wraparound autovacuums are taking up my vacuum workers so no analyze workers can run. Thanks! Gordon -- View this message in context: http://old.nabble.com/unexplained-autovacuum-to-prevent-wraparound-tp27883825p27883825.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
В списке pgsql-general по дате отправления: