This is a new one for me, one of our bigger (~2.2TB) databases started having the following error:
> Caused by: org.postgresql.util.PSQLException: ERROR: multixact "members" limit exceeded
> Detail: This command would create a multixact with 2 members, but the remaining space is only enough for 0 members.
> Hint: Execute a database-wide VACUUM in database with OID 33554 with reduced vacuum_multixact_freeze_min_age and vacuum_multixact_freeze_table_age settings.
We followed those VACUUM instructions, and now everything's back to normal.
Now it's just about preventing this. Our best guess at this point is the autovacuums aren't working fast enough. Sure enough this instance has our old values for:
autovacuum_vacuum_cost_delay: 20ms
autovacuum_vacuum_cost_limit: 200
We've since started using:
autovacuum_vacuum_cost_delay: 10ms
autovacuum_vacuum_cost_limit: 2000
We'll be updating those settings as soon as possible.
Just looking for some expert eyes on this problem. Are we on the track track? I.e. is making the autovacuumer run more aggressively our best bet to avoid this issue?
Thank you,
Steve
