On Tuesday 17 April 2007 16:30, Tom Lane wrote: > Carol Walter <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
