From: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg 8.1.2 performance issue |
Date: | 2006-03-28 16:40:40 |
Message-ID: | 200603280940.40763.pgsql@bluepolka.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sunday March 26 2006 9:14 am, Tom Lane wrote:
> "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...)
Yes, I'd definitely like to see those vacuums and analyzes logged
similarly to user-generated queries.
Ed
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Aufflick | 2006-03-28 16:47:53 | Re: Advantages of PostgreSQL over MySQL 5.0 |
Previous Message | karly | 2006-03-28 16:31:35 | Re: FAQ 1.1 |