From: Alvaro Herrera <alvherre@commandprompt.com>
To: Mitch Collinsworth <mitch@ccmr.cornell.edu>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Doug Gorley <doug.gorley@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: How can I tell if I'm autovacuuming?
Date: Tue, 25 May 2010 15:53:49 -0400
Message-ID: <1274817042-sup-6782@alvh.no-ip.org> (raw)
In-Reply-To: <Pine.LNX.4.62.1005251533410.11199@mirror.ccmr.cornell.edu>
References: <4BF7E14B.6030800@gorley.ca>
<1274548283.8730.99.camel@jd-desktop.unknown.charter.com>
<Pine.LNX.4.62.1005251433330.11199@mirror.ccmr.cornell.edu>
<1274813948-sup-8946@alvh.no-ip.org>
<Pine.LNX.4.62.1005251533410.11199@mirror.ccmr.cornell.edu>
Excerpts from Mitch Collinsworth's message of mar may 25 15:38:38 -0400 2010:
> On Tue, 25 May 2010, Alvaro Herrera wrote:
> > I'd say you're running 8.1, not 8.2 as initially stated.
>
> Well... yes. Sorry. I take it the answer is different then...
>
> So... How can I tell if I'm autovacuuming in 8.1.21?
Crank log_min_messages down to debug2 and check the log for DEBUG
messages talking about databases and tables processed by autovacuum.
(I think debug1 produces enough data, I can't recall precisely).
8.1 was the first release to sport integrated autovacuum. It was very
rough around the edges. If you're depending on its behavior, I suggest
you upgrade.
--
Álvaro Herrera <alvherre@commandprompt.com>
Command Prompt, Inc. -- The PostgreSQL Company
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: alvherre@commandprompt.com, mitch@ccmr.cornell.edu, jd@commandprompt.com, doug.gorley@gmail.com
Subject: Re: How can I tell if I'm autovacuuming?
In-Reply-To: <1274817042-sup-6782@alvh.no-ip.org>
* 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