Date: Tue, 16 Oct 2007 20:19:51 -0700
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
Message-ID: <20071016201951.267b066d@scratch>
In-Reply-To: <866613.1260.qm@web52305.mail.re2.yahoo.com>
References: <866613.1260.qm@web52305.mail.re2.yahoo.com>
Organization: Joshua D. Drake
Mime-Version: 1.0
Content-Type: multipart/signed; boundary="Sig_/4S9+atEA0xwJ8oMrKmQM/Q6";
	protocol="application/pgp-signature"; micalg=PGP-SHA1

--Sig_/4S9+atEA0xwJ8oMrKmQM/Q6
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

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

>=20
> Brian
>=20
> ----- Original Message ----
> From: Tom Lane <tgl@sss.pgh.pa.us>
>=20
> 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).
>=20
>             regards, tom lane
>=20
>=20
>=20
>=20
> ---------------------------(end of
> broadcast)--------------------------- TIP 5: don't forget to increase
> your free space map settings
>=20


--=20

      =3D=3D=3D The PostgreSQL Company: Command Prompt, Inc. =3D=3D=3D
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/


--Sig_/4S9+atEA0xwJ8oMrKmQM/Q6
Content-Type: application/pgp-signature; name=signature.asc
Content-Disposition: attachment; filename=signature.asc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHFX9ZATb/zqfZUUQRAqXYAJ946P0+bxFN1d4G5HTkMUba/onOKgCffDNU
yRc3l3em8y/Uj6KEVU5SCe8=
=NjJz
-----END PGP SIGNATURE-----

--Sig_/4S9+atEA0xwJ8oMrKmQM/Q6--