Re: 8.0.3 pg_autovacuum doesn't clear out stats table?

Поиск
Список
Период
Сортировка
От Robin Iddon
Тема Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
Дата
Msg-id 43FE48EF.4000409@edesix.com
обсуждение исходный текст
Ответ на Re: 8.0.3 pg_autovacuum doesn't clear out stats table?  (Robin Iddon <robin@edesix.com>)
Ответы Re: 8.0.3 pg_autovacuum doesn't clear out stats table?  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-admin
>
> In fact I just noticed that the number of stats tuples just climbed
> from 1236 to 2634.  The ins/del counts are still zero.  I ran analyze
> and the update counter went up only by 1232.  For pg_autovacuum to
> vacuum this table I need (2*2634)+1000 = 6268 updates, which is never
> going to happen.

At least not before the number of tuples has climbed to beyond that
count based on my experience to date!

Robin


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: 8.0.3 pg_autovacuum doesn't clear out stats table?
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: 8.0.3 pg_autovacuum doesn't clear out stats table?