Matthew T. O'Connor wrote:
> Alvaro Herrera wrote:
>> I'd like to hear other people's opinions on Darcy Buskermolen proposal
>> to have a log table, on which we'd register what did we run, at what
>> time, how long did it last, [...] 
> I think most people would just be happy if we could get autovacuum to
> log it's actions at a much higher log level.  I think that "autovacuum
> vacuumed table x" is important and shouldn't be all the way down at the
> debug level.

+1 here.  Even more than "autovacuum vacuumed table x", I'd like to see
"vacuum starting table x" and "vacuum done table x".  The reason I say
that is because the speculation "autovacuum might have been running"
is now a frequent phrase I hear when performance questions are asked.
If vacuum start and end times were logged at a much earlier level,
that feature plus log_min_duration_statement could easily disprove
the "vacuum might have been running" hypothesis.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to