Re: pg 8.1.2 performance issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: "chris smith" <dmagick(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg 8.1.2 performance issue
Date: 2006-03-26 16:14:58
Message-ID: 26496.1143389698@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ed L." <pgsql(at)bluepolka(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-26 16:16:24 Re: pg 8.1.2 performance issue
Previous Message Ed L. 2006-03-26 14:27:28 Re: pg 8.1.2 performance issue