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@xxxxxxxxxxx> 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
