Alvaro Herrera wrote: > 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. > Ahhh okay, I didnt know how to extract the age for a database. Learnt something new here. > 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? > My *_freeze_* values are: autovacuum_freeze_max_age = 200000000 #vacuum_freeze_min_age = 100000000 The vacuum_freeze_min_age is the default at 100 million (I assume). How much is the age decremented by on a vacuum run then?
