Hello.

I just had an outage on postgres 14 due to multixact members limit exceeded.

So the documentation says "There is a separate storage area which holds the
list of members in each multixact, which also uses a 32-bit counter and
which must also be managed."

Questions:
having a 32-bit counter on this separated storage means that there is a
global limit of multixact IDs for a database OID?

Is there a way to monitor this storage limit or counter using any pg_stat
table/view?

are foreign keys a big source of multixact IDs so not recommended on tables
with a lot of data and a lot of churn?

Thanks

-- 
Bruno da Silva

Reply via email to