Tom Lane wrote: > "Ed L." <pgsql@xxxxxxxxxxxxx> writes: > > With our set of 4 DBs, that amounts to once every 40 minutes for > > the given database. I see "LOG: autovacuum: processing > > database "xyz"" in the log, but I do not see any analyze/vacuum > > commands being issued at all (does it log when it > > analyzes/vacuums?). > > Not at the default logging level --- I think you have to go to DEBUG1 > or DEBUG2 to get info about per-table actions. (This ought to be > rethought, likely, as that will also clutter your log with a ton of > extraneous info...) Added to TODO: * Allow log_min_messages to be specified on a per-module basis This would allow administrators to see more detailed information from specific sections of the backend, e.g. checkpoints, autovacuum, etc. -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
