VACUUM FULL needed sometimes to prevent transaction ID wraparound?

Поиск
Список
Период
Сортировка
От Marinos Yannikos
Тема VACUUM FULL needed sometimes to prevent transaction ID wraparound?
Дата
Msg-id 44EB48A9.7030704@geizhals.at
обсуждение исходный текст
Ответы Re: VACUUM FULL needed sometimes to prevent transaction ID wraparound?  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: VACUUM FULL needed sometimes to prevent transaction ID wraparound?  ("Dave Dutcher" <dave@tridecap.com>)
Re: VACUUM FULL needed sometimes to prevent transaction  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-performance
Hello,

we're looking into the reason why we are getting warnings about
transaction ID wraparound despite a daily "vaccumdb -qaz". Someone is
claiming that VACUUM without FULL cannot reassign XIDs properly when
max_fsm_pages was set too low (it says so here too, but this is rather
old: http://www.varlena.com/GeneralBits/Tidbits/perf.html#maxfsmp). Is
this true, or do we have a different issue here? We're using 8.1.3 with
a database generated on 8.1.3 (i.e. not migrated from 7.x or anything
like that).

Thanks,
  Marinos

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

Предыдущее
От: "Thomas Samson"
Дата:
Сообщение: Re: query planner: automatic rescribe of LIKE to BETWEEN ?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: query planner: automatic rescribe of LIKE to BETWEEN ?