How is it possibile to check if autovacuum is running in 8.1.x?
"Show Autovacuum" gives me on and also i see evidence in logs where
autovacuum writes "LOG: autovacuum: processing database xxxx".
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).
Also I'm asking this because the size of the pg_clog is >200M and I am
worried about possible transaction ID wraparound failures...
Thank you,
Denis
Tom Lane ha scritto:
> Karl Denninger <karl@denninger.net> writes:
>
>> But... .shouldn't autovacuum prevent this? Is there some way to look in
>> a log somewhere and see if and when the autovacuum is being run - and on
>> what?
>>
>
> There's no log messages (at the default log verbosity anyway). But you
> could look into the pg_stat views for the last vacuum time for each table.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>