Re: MultiXactID Wrap-Around

paolo romano <paolo.romano@yahoo.it> writes:
> My doubts now concern MultixactID wrap-around management. 
> Afaics, it is possible to spawn multixactids so quickly to have a
> wrap-around and to start overwriting the data stored in the offset
> slru (but analogous considerations apply to the member slru as
> well).

I looked into this when the multixact code was written.  There is a
theoretical risk but I think it's entirely theoretical.  MXIDs are
unlikely to be consumed faster than XIDs over the long term, and also
can be recycled sooner.  So you'd run up against XID wraparound (which
we do defend against) first.
        regards, tom lane