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@xxxxxxxxxxxxx> 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 > > ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
