Re: Auto vacuum

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

 



Carol Walter wrote:
> Robert,
> 
> I did as you suggested and the values for autovacuum are null,  
> therefore I'm guessing it isn't running.  Since postgres reports that  
> it is running, what other things might keep in from running?

Too high thresholds?  All tables disabled in pg_autovacuum?  naptime set
too high?

I suggest you turn log_min_messages more verbose, to DEBUG2, and see if
there are any entries in there regarding autovacuum.  If it's running,
you would see it.  You would get a message after autovacuum_naptime
seconds.

How long is autovacuum_naptime anyway?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


[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