Re: When the last vacuum occured? It's necessary to run

Поиск
Список
Период
Сортировка
От Shridhar Daithankar
Тема Re: When the last vacuum occured? It's necessary to run
Дата
Msg-id 3F9E0165.3070807@myrealbox.com
обсуждение исходный текст
Ответ на When the last vacuum occured? It's necessary to run it now?  ("Thiago Fernandes Moesch" <thiago@dinamize.com>)
Список pgsql-hackers
Thiago Fernandes Moesch wrote:
>   It would be great for maintainance if every object had a timestamp of
> the last vaccum run on it. From time to time we're working with several
> databases and I can't tell wich one needs a new vacuum.
> 
>   Another important information would be the rate of disposable data in
> every table (like old and delete records) it would help was to
> determine if a vacuum is required.

You could rather use autovacuum than adding timestamps to fields.

HTH
 Shridhar



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

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Duplicating transaction information in indexes and
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: Open items