Re: Problem with autovacuum and pg_autovacuum

Поиск
Список
Период
Сортировка
От Pavan Deolasee
Тема Re: Problem with autovacuum and pg_autovacuum
Дата
Msg-id 2e78013d0707052300u6d8a8ba9l4ce4c35eba35dc2f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problem with autovacuum and pg_autovacuum  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Ответы Re: Problem with autovacuum and pg_autovacuum  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Список pgsql-general


On 7/5/07, Andreas 'ads' Scherbaum <adsmail@wars-nicht.de> wrote:

Hello,

On Wed, 4 Jul 2007 18:04:35 -0400 Alvaro Herrera wrote:

> Most likely it is worried about XID wraparound, and those are precisely
> the tables that need urgent vacuumed because they haven't been vacuumed
> in a long time.

No, autovacuum is doing this with every run. Beside this, the database has
only some 10k changes per day. The wraparound was my first idea, but i
don't see a reason, why this should be happen with every autovacuum run.


Did you check freeze_max_age values in the pg_autovacuum table ? A very
small value can trigger XID wraparound related VACUUMs in every run.

Thanks,
Pavan

--
Pavan Deolasee
EnterpriseDB     http://www.enterprisedb.com

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

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: Localization trouble
Следующее
От: Hannes Dorbath
Дата:
Сообщение: Re: tsearch2 in multilingual database?