Multixact wraparound monitoring

bruno vieira da silva <brunogiovs@gmail.com>

From: bruno da silva <brunogiovs@gmail.com>
To: pgsql-performance@lists.postgresql.org
Date: 2023-09-13T12:21:40Z
Lists: pgsql-performance
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