Joe Maldonado wrote:
I have not seen any information so far on this but is there a way to get the autovacuum daemon in PostgreSQL 8.1 to log the tables which it is perfoming vacuum or analyze operation on?
I think the autovacuum daemon does log it's activity however all it's output is set at DEBUG2 or DEBUG3, so you would have to turn up the logging settings for the whole postmaster in order to see it. I think perhaps these should be INFO or something a little more common.
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
