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
|
Список | 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 по дате отправления: