Re: Multixact wraparound monitoring

2023-09-14 Thread bruno da silva
This problem is more acute when the FK Table stores a small number of rows like types or codes. I think in those cases an enum type should be used instead of a column with a FK. Thanks. On Thu, Sep 14, 2023 at 7:23 AM Alvaro Herrera wrote: > On 2023-Sep-13, bruno da silva wrote: > > > I just had

Re: Multixact wraparound monitoring

2023-09-14 Thread Alvaro Herrera
On 2023-Sep-13, bruno da silva wrote: > I just had an outage on postgres 14 due to multixact members limit exceeded. Sadly, that's not as uncommon as we would like. > So the documentation says "There is a separate storage area which holds the > list of members in each multixact, which also uses