unexplained autovacuum to prevent wraparound

From: Gordon Shannon <gordo169(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: unexplained autovacuum to prevent wraparound
Date: 2010-03-12 22:49:13
Message-ID: 27883825.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-03-12 23:31:30 Re: unexplained autovacuum to prevent wraparound
Previous Message Jan 2010-03-12 22:04:37 static build from source on windows