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