From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Brian Herlihy <btherl(at)yahoo(dot)com(dot)au>, Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Vacuum goes worse |
Date: | 2007-10-17 13:43:28 |
Message-ID: | 20071017134328.GA5737@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Joshua D. Drake wrote:
> On Tue, 16 Oct 2007 17:03:39 -0700 (PDT)
> Brian Herlihy <btherl(at)yahoo(dot)com(dot)au> wrote:
>
> > Would it make sense to show the FSM stats for individual table
> > vaccums as well? I'm wondering if the reason they aren't shown is
> > because it wouldn't be useful or isn't practical, or just that it
> > hasn't been done.
>
> I am not sure how useful it would be as the FSM is global. However what
> would be useful is something like VACUUM SUMMARY, where I could get
> "just" the stats instead of all the other output that comes along with
> VERBOSE.
What would be really useful is to remove all that noise from vacuum and
make it appear on a view. 8.4 material all of this, of course.
--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
"Estoy de acuerdo contigo en que la verdad absoluta no existe...
El problema es que la mentira sí existe y tu estás mintiendo" (G. Lama)
From | Date | Subject | |
---|---|---|---|
Next Message | Stefano Dal Pra | 2007-10-17 14:35:16 | Re: Vacuum goes worse |
Previous Message | Heikki Linnakangas | 2007-10-17 13:39:50 | Re: two queryes in a single tablescan |