Message-ID: <418FA179.70408@Yahoo.com>
Date: Mon, 08 Nov 2004 11:40:25 -0500
From: Jan Wieck <JanWieck@Yahoo.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.7.1) Gecko/20040707
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Marc G. Fournier" <scrappy@postgresql.org>,
	Justin Clift <justin@postgresql.org>, pgsql-hackers@postgresql.org
Subject: Re: [pgsql-www] pg_autovacuum is nice ... but ...
References: <20041103155855.O82047@ganymede.hub.org>
	<41895BDA.1090903@postgresql.org>
	<20041103201625.S82047@ganymede.hub.org>
	<19430.1099533223@sss.pgh.pa.us> <418AA915.7010903@postgresql.org>
	<20041104182322.D21566@ganymede.hub.org>
	<6789.1099608272@sss.pgh.pa.us>
In-Reply-To: <6789.1099608272@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

On 11/4/2004 5:44 PM, Tom Lane wrote:

> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> Moved to -hackers where this belongs :)
> 
>> On Fri, 5 Nov 2004, Justin Clift wrote:
>>> Would making max_fsm_relations and max_fsm_pages dynamically update 
>>> themselves whilst PostgreSQL runs be useful?
> 
> Possibly, but it isn't happening in the foreseeable future, for the same
> reason that we don't auto-update shared_buffers and the other shared
> memory sizing parameters: we can't resize shared memory on the fly.
> 
>> I'm not sure if I like this one too much ... but it would be nice if 
>> something like this triggered a warning in the logs, maybe a feature of 
>> pg_autovacuum itself?
> 
> autovacuum would probably be a reasonable place to put it.  We don't
> currently have any good way for autovacuum to get at the information,
> but I suppose that an integrated autovacuum daemon could do so.

Don't know why this must be an "integrated" autovacuum. Can't the info 
about the FSM usage be presented as system views?


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #