Denis Gasparin wrote: > 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". Then it is running. > 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. -- Alvaro Herrera Developer, http://www.PostgreSQL.org/ "A wizard is never late, Frodo Baggins, nor is he early. He arrives precisely when he means to." (Gandalf, en LoTR FoTR) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
