Re: Autovacuum / full vacuum (off-topic?) - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Autovacuum / full vacuum (off-topic?)
Date
Msg-id 43D01C68.3030204@paradise.net.nz
Whole thread Raw
In response to Re: Autovacuum / full vacuum (off-topic?)  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Autovacuum / full vacuum (off-topic?)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Autovacuum / full vacuum (off-topic?)  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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


pgsql-performance by date:

Previous
From: Alex Turner
Date:
Subject: Re: 3WARE Card performance boost?
Next
From: Bruce Momjian
Date:
Subject: Re: Autovacuum / full vacuum (off-topic?)