Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 12D3D9FB676
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 17 Oct 2007 12:56:20 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 71476-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 17 Oct 2007 12:55:59 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id BAB889FB5D4
	for <pgsql-performance@postgresql.org>;
	Wed, 17 Oct 2007 12:56:16 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l9HFuEFI006850;
	Wed, 17 Oct 2007 11:56:14 -0400 (EDT)
To: Alvaro Herrera <alvherre@commandprompt.com>
cc: "Joshua D. Drake" <jd@commandprompt.com>,
	Brian Herlihy <btherl@yahoo.com.au>,
	Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Vacuum goes worse 
In-reply-to: <20071017134328.GA5737@alvh.no-ip.org> 
References: <866613.1260.qm@web52305.mail.re2.yahoo.com>
	<20071016201951.267b066d@scratch>
	<20071017134328.GA5737@alvh.no-ip.org>
Comments: In-reply-to Alvaro Herrera <alvherre@commandprompt.com>
	message dated "Wed, 17 Oct 2007 10:43:28 -0300"
Date: Wed, 17 Oct 2007 11:56:14 -0400
Message-ID: <6849.1192636574@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/205
X-Sequence-Number: 27227

Alvaro Herrera <alvherre@commandprompt.com> writes:
> What would be really useful is to remove all that noise from vacuum and
> make it appear on a view.

Well, if you want something decoupled from VACUUM there's already
contrib/pg_freespacemap.

> 8.4 material all of this, of course.

I am hoping that we rewrite FSM into the distributed DSM structure
that's been talked about, so that the whole problem goes away in 8.4.

			regards, tom lane