Re: Autovacuum / full vacuum (off-topic?)

Mark Kirkwood <markir@paradise.net.nz>

From: Mark Kirkwood <markir@paradise.net.nz>
To: "Jim C. Nasby" <jnasby@pervasive.com>
Cc: Michael Crozier <crozierm@conducivetech.com>, pgsql-performance@postgresql.org
Date: 2006-01-19T23:10:32Z
Lists: pgsql-performance
Jim C. Nasby wrote:

> 
> I think it's a good idea, but you should take a look at the recently
> added functionality that allows you to investigate the contests of the
> FSM via a user function (this is either in 8.1 or in HEAD; I can't
> remember which).

AFAICS it is still in the patch queue for 8.2.

It's called 'pg_freespacemap' and is available for 8.1/8.0 from the 
Pgfoundry 'backports' project:

http://pgfoundry.org/projects/backports

Cheers

Mark