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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas F. O'Connell 2007-04-18 23:11:51 pg_standby, Restartable Recovery after Hard Failure
Previous Message David Hinkle 2007-04-18 19:35:26 Re: Toast Problems