vacuum tx id wraparound issues

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux