From: Joshua D. Drake <jd@commandprompt.com>
To: Brian Herlihy <btherl@yahoo.com.au>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Vacuum goes worse
Date: Tue, 16 Oct 2007 20:19:51 -0700
Message-ID: <20071016201951.267b066d@scratch> (raw)
In-Reply-To: <866613.1260.qm@web52305.mail.re2.yahoo.com>
References: <866613.1260.qm@web52305.mail.re2.yahoo.com>
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.
Joshua D. Drake
>
> Brian
>
> ----- Original Message ----
> From: Tom Lane <tgl@sss.pgh.pa.us>
>
> If you're talking about the FSM statistics display, that only gets
> printed by a database-wide VACUUM (one that doesn't name a specific
> table).
>
> regards, tom lane
>
>
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 5: don't forget to increase
> your free space map settings
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/Attachments:
signature.asc (application/pgp-signature, 188B) download
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: jd@commandprompt.com, btherl@yahoo.com.au
Subject: Re: Vacuum goes worse
In-Reply-To: <20071016201951.267b066d@scratch>
* 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