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