From: Alvaro Herrera <alvherre@commandprompt.com>
To: Joshua D. Drake <jd@commandprompt.com>
Cc: Brian Herlihy <btherl@yahoo.com.au>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Vacuum goes worse
Date: Wed, 17 Oct 2007 10:43:28 -0300
Message-ID: <20071017134328.GA5737@alvh.no-ip.org> (raw)
In-Reply-To: <20071016201951.267b066d@scratch>
References: <866613.1260.qm@web52305.mail.re2.yahoo.com>
<20071016201951.267b066d@scratch>
Joshua D. Drake wrote:
> On Tue, 16 Oct 2007 17:03:39 -0700 (PDT)
> Brian Herlihy <btherl@yahoo.com.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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, jd@commandprompt.com, btherl@yahoo.com.au
Subject: Re: Vacuum goes worse
In-Reply-To: <20071017134328.GA5737@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox