Re: preventing ERROR: multixact "members" limit exceeded

Поиск
Список
Период
Сортировка
От Steve Kehlet
Тема Re: preventing ERROR: multixact "members" limit exceeded
Дата
Msg-id CA+bfosHXSoVC0o3j-ic2T_nDUoPHRte=vtf9xMsd6s7upWeN_Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: preventing ERROR: multixact "members" limit exceeded  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: preventing ERROR: multixact "members" limit exceeded  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
On Mon, May 16, 2016 at 6:18 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
Not really.  Your best bet is to reduce the
autovacuum_multixact_freeze_min_age limit, so that vacuums are able to
get rid of multixacts sooner (and/or reduce
autovacuum_multixact_freeze_table_age, so that whole-table vacuuming
takes place earlier).

Thank you very much. I will adjust those settings. Is there a way, something similar to keeping an eye on `age(relfrozenxid)`, that I can watch this and keep an eye on it before it becomes a problem? 

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

Предыдущее
От: Vik Fearing
Дата:
Сообщение: Re: WAL files not being recycled
Следующее
От: Guyren Howe
Дата:
Сообщение: FIRST_VALUE argument must appear in group by?