On Sunday March 26 2006 9:14 am, Tom Lane wrote: > "Ed L." <[EMAIL PROTECTED]> 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...)
Yes, I'd definitely like to see those vacuums and analyzes logged similarly to user-generated queries. Ed ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
