Re: Multixact wraparound monitoring

2023-09-13 Thread Wyatt Alt
On Wed, Sep 13, 2023 at 8:29 AM bruno da silva wrote: > > are foreign keys a big source of multixact IDs so not recommended on > tables with a lot of data and a lot of churn? > I am curious to hear other answers or if anything has changed. I experienced this problem a couple of times on PG 11. I

Multixact wraparound monitoring

2023-09-13 Thread bruno da silva
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