Re: Is it normal for Autovacuum running continuously?

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

 



Michael Goldner wrote:
> I notice in my postgres logfile that autovacuum is running every minute.
> The server had no overnight activity, yet this has been going on for days.
> Overall performance of the database seems to be slow, and I assume that it
> is related.

It is normal.  I doubt your performance problem is related to
autovacuum.  When you say "overall performance seems to be slow", it
means you haven't actually measured individual queries and found that
they are actually slow, no?

> I'm running 8.1.4 on Redhat EL4.3.
> 
> Is this normal for autovacuum?

Yes.

-- 
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