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

Re: Auto vacuum

From: Robert Treat <robert(at)omniti(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Carol Walter <walterc(at)indiana(dot)edu>
Subject: Re: Auto vacuum
Date: 2007-04-18 01:57:53
Message-ID: 200704172157.54249.robert@omniti.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Tuesday 17 April 2007 16:30, Tom Lane wrote:
> Carol Walter <walterc(at)indiana(dot)edu> writes:
> > 8.2.3 is what is reported when I run psql with the -V option.
>
> In 8.2 you need to increase log_min_messages to see anything about
> autovacuum.  It reports per-database activity at DEBUG1 and per-table
> activity at DEBUG2 level.  Unfortunately DEBUG2 will fill your log
> with a lot of other chatter as well :-(.  There's work going on
> right now to improve the reporting of autovac activity for 8.3.
>

Till then, take a look at pg_stat_all_tables, which contains information on 
last autovacuum and autoanalyze runs for each table. 

-- 
Robert Treat
Database Architect
http://www.omniti.com

In response to

Responses

pgsql-admin by date

Next:From: Robert TreatDate: 2007-04-18 02:01:48
Subject: Re: Checking a size of a given database
Previous:From: Jessica RichardDate: 2007-04-18 00:34:18
Subject: who can tell me the correct syntax to use dblink to talk to a table in another database

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