| 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: | Whole Thread | Raw Message | 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. |