Re: preventing ERROR: multixact "members" limit exceeded - Mailing list pgsql-general

From Steve Kehlet
Subject Re: preventing ERROR: multixact "members" limit exceeded
Date
Msg-id CA+bfosHXSoVC0o3j-ic2T_nDUoPHRte=vtf9xMsd6s7upWeN_Q@mail.gmail.com
Whole thread Raw
In response to Re: preventing ERROR: multixact "members" limit exceeded  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: preventing ERROR: multixact "members" limit exceeded
List 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 by date:

Previous
From: Vik Fearing
Date:
Subject: Re: WAL files not being recycled
Next
From: Guyren Howe
Date:
Subject: FIRST_VALUE argument must appear in group by?