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

Re: Auto vacuum

From: Carol Walter <walterc(at)indiana(dot)edu>
To: Robert Treat <robert(at)omniti(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Auto vacuum
Date: 2007-04-18 21:29:04
Message-ID: 12A54BAC-0218-40F8-9A8A-26C6268D1617@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
Robert,

I did as you suggested and the values for autovacuum are null,  
therefore I'm guessing it isn't running.  Since postgres reports that  
it is running, what other things might keep in from running?

Carol Walter
On Apr 17, 2007, at 9:57 PM, Robert Treat wrote:

> 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: Thomas F. O'ConnellDate: 2007-04-18 23:11:51
Subject: pg_standby, Restartable Recovery after Hard Failure
Previous:From: David HinkleDate: 2007-04-18 19:35:26
Subject: Re: Toast Problems

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