Re: [pgsql-www] pg_autovacuum is nice ... but ... - Mailing list pgsql-hackers

From Marc G. Fournier
Subject Re: [pgsql-www] pg_autovacuum is nice ... but ...
Date
Msg-id 20041104221815.I21566@ganymede.hub.org
Whole thread Raw
In response to Re: [pgsql-www] pg_autovacuum is nice ... but ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, 4 Nov 2004, Tom Lane wrote:

>> 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.

You had mentioned doing the select on pg_class for the relations variable 
... pg_autovacuum could just as easily do that as part of its start up 
routine, no?  when it 'loads' all the table information?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


pgsql-hackers by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: CVS should die
Next
From: "Kronuz !"
Date:
Subject: New ISBN/ISSN/ISMN/EAN13 module.