"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...)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
