Re: AutoVacuum Behaviour Question

Bruce McAlister wrote:

Ok now this is interesting:

> select datname, age(datfrozenxid) from pg_database;
>          datname         |    age
> -------------------------+-----------
>  blueface-crm            | 441746613

Note this value is 440 million, and you said in your original report that

> autovacuum_freeze_max_age = 200000000

200 million.  So this database is being selected each time because of
this.

However, what should happen is that after the vacuum the age of the
database is decreased after the vacuuming.  What's your
vacuum_freeze_min_age setting?

--
Alvaro Herrera                         http://www.flickr.com/photos/alvherre/
"Everything that I think about is more fascinating than the crap in your head."
                               (Dogbert's interpretation of blogger philosophy)