Re: pg 8.1.2 performance issue

"Ed L." <pgsql@bluepolka.net> 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