Re: MultiXactID Wrap-Around - Mailing list pgsql-hackers

From Tom Lane
Subject Re: MultiXactID Wrap-Around
Date
Msg-id 3276.1151940116@sss.pgh.pa.us
Whole thread Raw
In response to MultiXactID Wrap-Around  (paolo romano <paolo.romano@yahoo.it>)
Responses Re: MultiXactID Wrap-Around  (paolo romano <paolo.romano@yahoo.it>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: CVS mirror, was Re: [PATCHES] ADD/DROPS INHERIT (actually INHERIT / NO INHERIT)
Next
From: "Marc G. Fournier"
Date:
Subject: Re: CVS mirror, was Re: [PATCHES] ADD/DROPS INHERIT (actually INHERIT