Horton

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

Marc Fournier <scrappy@postgresql.org>

View thread View on postgr.es
From: "Marc G. Fournier" <scrappy@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Marc G. Fournier" <scrappy@postgresql.org>, Justin Clift <justin@postgresql.org>, pgsql-hackers@postgresql.org
Date: 2004-11-05T02:19:12Z
Lists: 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