Re: Vacuum summary?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Vacuum summary?
Дата
Msg-id 1121243393.3970.122.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Vacuum summary?  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Vacuum summary?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
On Tue, 2005-07-12 at 14:56 -0700, Joshua D. Drake wrote:
> > It'd be relatively easy I think to extract the current FSM statistics
> > in a function that could be invoked separately from VACUUM.  Not sure
> > how we ought to return 'em though --- the VACUUM way of a bunch of INFO
> > messages is a bit old-fashioned.  Maybe a statistics view?
> 
> That would work for me.

Sounds good.

I would also like the statistics view to show when all the FSM tracked
pages are used up for a particular relation and the relation needs
vacuuming. That way we can integrate it with autovacuum.

Best Regards, Simon Riggs



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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Order by optimisations?
Следующее
От: Simon Riggs
Дата:
Сообщение: A Guide to Constraint Exclusion (Partitioning)