Re: How can I tell if I'm autovacuuming? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: How can I tell if I'm autovacuuming?
Date
Msg-id 1274817042-sup-6782@alvh.no-ip.org
Whole thread Raw
In response to Re: How can I tell if I'm autovacuuming?  (Mitch Collinsworth <mitch@ccmr.cornell.edu>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Mitch Collinsworth
Date:
Subject: Re: How can I tell if I'm autovacuuming?
Next
From: Samuel Stearns
Date:
Subject: Re: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3