Re: autovacuum daemon question...

[Joe Maldonado <joe.maldonado@xxxxxxxxx>]

I agree...for now while I'm developing and debugging my application I
can have the logging be that verbose...I agree that these should be
handled as info messages, since they are invaluable in investigating
problems.




- Joe

On 11/9/05, Matthew T. O'Connor <matthew@xxxxxxxx> wrote:

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.

-- 
Joe Maldonado