From: Michael Crozier <crozierm@conducivetech.com>
To: pgsql-performance@postgresql.org
Subject: Re: Autovacuum / full vacuum (off-topic?)
Date: Wed, 18 Jan 2006 15:36:04 -0800
User-Agent: KMail/1.8.3
References: <dqigaf$1b98$1@news.hub.org>
	<200601181115.51850.crozierm@conducivetech.com>
	<20060118225257.GY17896@pervasive.com>
In-Reply-To: <20060118225257.GY17896@pervasive.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200601181536.04758.crozierm@conducivetech.com>


On Wednesday 18 January 2006 14:52 pm, 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).

I will look at this when time allows.  Perhaps there is a combination of 
triggers on stat tables and asynchronous notifications that would provide 
this functionality without getting too deep into the vacuum's transaction 
logic?

Were it too integrated with the vacuum, it would likely be too much for 
contrib/, I assume.


thanks,

  Michael