From: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | vacuum tx id wraparound issues |
Date: | 2009-06-25 11:16:05 |
Message-ID: | 200906250516.05265.kevink@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-06-25 14:25:53 | Re: vacuum tx id wraparound issues |
Previous Message | Green Idol | 2009-06-25 08:28:53 | himanshu purohit wants you to be a Green Idol. |