Re: AutoVacuum and growing transaction XID's

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: AutoVacuum and growing transaction XID's
Дата
Msg-id CAHOFxGpH-+ayDCqBekhCp4eU0ZWtRK4ob9nRs6_8zQXdC95HFQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: AutoVacuum and growing transaction XID's  (github kran <githubkran@gmail.com>)
Ответы Re: AutoVacuum and growing transaction XID's
Re: AutoVacuum and growing transaction XID's
Список pgsql-general
autovacuum_naptime being only 5 seconds seems too frequent. A lock_timeout might be 1-5 seconds depending on your system. Usually, DDL can fail and wait a little time rather than lock the table for minutes and have all reads back up behind the DDL.

Given you have autovacuum_vacuum_cost_limit set to unlimited (seems very odd), I'm not sure a manual vacuum freeze command on the tables with high age would perform differently. Still, issuing a vacuum freeze and then killing the autovacuum process might be worth trying.

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

Предыдущее
От: Rob Sargent
Дата:
Сообщение: Re: Thoughts on how to avoid a massive integer update.
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_basebackup cannot compress to STDOUNT