Re: Question regarding autovacuum in 8.1

[Denis Gasparin <denis@xxxxxxxxxxx>]

Alvaro Herrera ha scritto:

However i have no idea of what tables the autovacuum daemon is
processing because there aren't autovacuum info columns on
pg_stat_all_tables (as there are for 8.2.x).
    

For that, you need to change log_min_messages to debug2.

Keep track of the PID of autovacuum from the "processing database"
message and see if you can spot an ERROR message from it.

  

Ok. Thank you.
Another question/idea: why don't put messages about what tables got vacuumed by the autovacuum daemon as normal log messages (instead of debug2)?
I think it could be useful because in this way you can also know what tables are used more often then other...
If i'm not wrong, the old autovacuum process in 7.4 and 8.0 did that...

Denis