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

From Bruce Momjian
Subject Re: pg 8.1.2 performance issue
Date
Msg-id 200604102107.k3AL71D03294@candle.pha.pa.us
Whole thread Raw
In response to Re: pg 8.1.2 performance issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> "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...)

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. +

pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Workaround for custom aggregate which would need "internal" as statetype
Next
From: Hugo
Date:
Subject: trigger firing order