Re: Auto vacuum

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