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) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
