Re: pg 8.1.2 performance issue - Mailing list pgsql-general

From Tom Lane
Subject Re: pg 8.1.2 performance issue
Date
Msg-id 26496.1143389698@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg 8.1.2 performance issue  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: pg 8.1.2 performance issue  ("Ed L." <pgsql@bluepolka.net>)
Re: pg 8.1.2 performance issue  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: pg 8.1.2 performance issue
Next
From: Tom Lane
Date:
Subject: Re: pg 8.1.2 performance issue