From: Todd Gugler <tgugler11@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Can autovacuum result in large surges in WAL files
Date: Tue, 3 May 2011 12:22:33 -0500
Message-ID: <CBFC2500-5ADB-48FD-AC3B-C450E02E9F6A@gmail.com> (raw)
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgugler11@gmail.com
Subject: Re: Can autovacuum result in large surges in WAL files
In-Reply-To: <CBFC2500-5ADB-48FD-AC3B-C450E02E9F6A@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox