Can autovacuum result in large surges in WAL files

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

 



I have a Postgres 8.3 system that is configured to run autovacuum.  It triggered a vacuum analyze on multiple tables and since this started, we are getting large numbers of WAL files generated about every 15 minutes or so.  This same vacuum appears to continuing to run.  Other database activity is at its usual levels.  Should a vacuum analyze lead to large amounts of data being written to WAL files?  We are seeing 10x the number WAL files that we would expect.

Any ideas on the best approach to diagnose what is going on?
-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[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