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

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: [pgsql-www] pg_autovacuum is nice ... but ...
Дата
Msg-id 20041104221815.I21566@ganymede.hub.org
обсуждение исходный текст
Ответ на Re: [pgsql-www] pg_autovacuum is nice ... but ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Gaetano Mendola
Дата:
Сообщение: Re: CVS should die
Следующее
От: "Kronuz !"
Дата:
Сообщение: New ISBN/ISSN/ISMN/EAN13 module.