Postgres Pro
Downloads
Home   >   mailing lists

Can autovacuum result in large surges in WAL files - Mailing list pgsql-admin

From Todd Gugler
Subject Can autovacuum result in large surges in WAL files
Date
Msg-id CBFC2500-5ADB-48FD-AC3B-C450E02E9F6A@gmail.com
Whole thread Raw
Responses Re: Can autovacuum result in large surges in WAL files
List pgsql-admin
Tree view 
I have a Postgres 8.3 system that is configured to run autovacuum.  It triggered a vacuum analyze on multiple tables
andsince this started, we are getting large numbers of WAL files generated about every 15 minutes or so.  This same
vacuumappears to continuing to run.  Other database activity is at its usual levels.  Should a vacuum analyze lead to
largeamounts 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?

pgsql-admin by date:

Previous
From: "Mark Johnson"
Date:
Subject: Re: Can we Flush the Postgres Shared Memory ?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Can autovacuum result in large surges in WAL files