Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?

Поиск
Список
Период
Сортировка
От Aleksey Tsalolikhin
Тема Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?
Дата
Msg-id AANLkTikV-4f5E6lSP5M5hJ2M6-ABxMm5XQ7brQb78I16@mail.gmail.com
обсуждение исходный текст
Ответ на check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Ответы Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?  (Aleksey Tsalolikhin <atsaloli.tech@gmail.com>)
Список pgsql-general
Дерево обсуждения 
I just ran the "last_autovacuum" test of check_postgres, and it reported

7 (of my 100) tables have been autovacuumed more than 1 day ago;
the oldest autovacuum time was 7 weeks ago.

8 more tables in pg_catalog were autovacuumed more than 1 day ago.

Thanks,
-at

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

Предыдущее
От: Aleksey Tsalolikhin
Дата:
Сообщение: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?
Следующее
От: Aleksey Tsalolikhin
Дата:
Сообщение: Re: check_postgres reports most of my tables are unanalyzed for 8 weeks; why isn't autovacuum analyzing them?