Search Postgresql Archives

Re: Why pgAdmin III guru suggests VACUUM in 8.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Matthew T. O'Connor" <matthew@xxxxxxxx> writes:
>> LOG:  autovacuum: processing database "foo"

> Also this creates a lot of noise in the log files.  I think it would be 
> better to downgrade this message to a NOTICE or even a DEBUG, and 
> replace it with a LOG level message that states when action has taken 
> place against the table.

I agree that the "processing database" message isn't too exciting, but
it seems that forcing per-table messages up to LOG level would create
even more log clutter.  I could support "processing table" at level
DEBUG1 and "processing database" at DEBUG2.  Or maybe we should think
harder about the idea recently mentioned of letting the autovacuum
process have its own log-level setting, separate from ordinary backends'
setting.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux