Re: unexplained autovacuum to prevent wraparound

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: unexplained autovacuum to prevent wraparound
Дата
Msg-id 20100312233130.GL3663@alvh.no-ip.org
обсуждение исходный текст
Ответ на unexplained autovacuum to prevent wraparound  (Gordon Shannon <gordo169@gmail.com>)
Ответы Re: unexplained autovacuum to prevent wraparound  (Gordon Shannon <gordo169@gmail.com>)
Список pgsql-general
Gordon Shannon escribió:

> One possibly interesting thing is that this seems to have started just after
> I set foo's autovacuum_analyze_scale_factor to 0.01, since I wanted more
> frequent analyze runs.  I wonder if that could be related.

You probably set the other values to 0, which includes the freeze age.
You need to set it (and all other values) to -1 instead.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

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

Предыдущее
От: Gordon Shannon
Дата:
Сообщение: unexplained autovacuum to prevent wraparound
Следующее
От: Gordon Shannon
Дата:
Сообщение: Re: unexplained autovacuum to prevent wraparound