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.
In response to
pgsql-admin by date
|Next:||From: Robert Treat||Date: 2007-04-18 02:01:48|
|Subject: Re: Checking a size of a given database|
|Previous:||From: Jessica Richard||Date: 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|