Hi all; I'm seeing a number of vacuum's in one of our db's that has a notation (to prevent wraparound).
I've tried a number of things to fix it. last nite during the off hours we ran a "vacuumdb -a" The vacuumdb did vacuum every db in the cluster but I'm still seeing the vacuums to prevent wraparound. a few days ago this query showed an avg of 200million for the age, now its 100million. postgres=# select datname, age(datfrozenxid) from pg_database; datname | age -----------+----------- template1 | 36020008 template0 | 36017769 postgres | 101264283 report | 101264283 kabc | 100009842 prod | 101264283 quota | 101264283 cfg | 101264283 (8 rows) why did the vacuumdb -a not clear this up for us? Thanks in advance
