From: Ian Westmacott <ianw@intellivid.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: 8.1.8 autovacuum missing databases
Date: Tue, 29 Apr 2008 17:05:03 -0400
Message-ID: <1209503103.18622.68.camel@vega.intellivid.com> (raw)
In-Reply-To: <20080429203335.GK5652@alvh.no-ip.org>
References: <1209499373.18622.47.camel@vega.intellivid.com>
<20080429203335.GK5652@alvh.no-ip.org>
On Tue, 2008-04-29 at 16:33 -0400, Alvaro Herrera wrote:
> Is autovacuum dying before being able to finish the vacuuming of
> template1 or the other database?
Not as far as I can tell. There are no indications of any crash or
error in the log file (I just bumped the log level up to debug1). Just
autovacuum processing template1 or the one other database every minute.
I ran VACUUM ANALYZE on both template1 and the one database manually
just to make sure there wasn't a lock or something preventing
completion, but they both completed without error.
--Ian
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: ianw@intellivid.com, alvherre@commandprompt.com
Subject: Re: 8.1.8 autovacuum missing databases
In-Reply-To: <1209503103.18622.68.camel@vega.intellivid.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