Skip site navigation (1) Skip section navigation (2)

Re: How can I tell if I'm autovacuuming?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Mitch Collinsworth <mitch(at)ccmr(dot)cornell(dot)edu>
Cc: Joshua D(dot) Drake <jd(at)commandprompt(dot)com>, Doug Gorley <doug(dot)gorley(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How can I tell if I'm autovacuuming?
Date: 2010-05-25 19:53:49
Message-ID: 1274817042-sup-6782@alvh.no-ip.org (view raw or flat)
Thread:
Lists: 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(at)commandprompt(dot)com>
Command Prompt, Inc.  -- The PostgreSQL Company

In response to

pgsql-admin by date

Next:From: Samuel StearnsDate: 2010-05-25 22:45:05
Subject: Re: Quickest command to dump and restore the database? : pg_dump and pg_restore? using PostgreSQL 8.3 running on RedHat 5.3
Previous:From: Mitch CollinsworthDate: 2010-05-25 19:38:38
Subject: Re: How can I tell if I'm autovacuuming?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group