| 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: | Whole Thread | Raw Message | 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.
| 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 |