Re: Autovacuum Improvements

Поиск
Список
Период
Сортировка
От Glen Parker
Тема Re: Autovacuum Improvements
Дата
Msg-id 45886306.1040009@nwlink.com
обсуждение исходный текст
Ответ на Re: Autovacuum Improvements  (Erik Jones <erik@myemma.com>)
Ответы Re: Autovacuum Improvements  (Matthew O'Connor <matthew@zeut.net>)
Список pgsql-general
Erik Jones wrote:
> Matthew O'Connor wrote:
>> Glen Parker wrote:
>>> If it isn't there somewhere already, I would ask to add:
>>>  Expose a very easy way to discover autovacuum's opinion about a
>>> particular table, for example "table_needs_vacuum(oid)", ignoring any
>>> time constraints that may be in place.
>>
>> This might be a nice feature however in the presence of the much
>> talked about but not yet developed maintenance window concept, I'm not
>> sure how  this should work.  That is, during business hours the table
>> doesn't need vacuuming, but it will when the evening maintenance
>> window opens up.
 >
> Well, what he's saying is, "Not taking into account any time/maintenance
> windows, does this table need vacuuming?"

Correct.  IOW, "does it need it?", not "would you actually do it at this
time?"...

-Glen



В списке pgsql-general по дате отправления:

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: Autovacuum Improvements
Следующее
От: Glen Parker
Дата:
Сообщение: Re: Autovacuum Improvements