Should autovacuum do a database wide vacuum near transaction limit?

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

 



Hi,  I'm running 8.3.9 on ubuntu with autovacuum enabled and seemingly working properly., however I've started getting messages saying that I'm near the transaction limit and I need to do a database wide vacuum, which I've started.

From reading the docs, though I thought that autovacuum would do this on my behalf, is this true? I would have expected it to run before I started getting warnings, or does it wait until the warnings start? If not, is there any config setting or other reason why autovacuum isn't doing a database wide vacuum as expected or do I always need to do a manual one?

Thanks

John
--
 
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/

[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