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

From paolo romano
Subject Re: MultiXactID Wrap-Around
Date
Msg-id 20060704104111.46656.qmail@web27813.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: MultiXactID Wrap-Around  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Thank you for the feed-back. In fact the risk seems neglibible, but it means that at least I'm not misunderstanding
whatthat code does...<br /><br /><br /><b><i>Tom Lane <tgl@sss.pgh.pa.us></i></b> ha scritto: <blockquote
class="replbq"style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> paolo romano
writes:<br/>> My doubts now concern MultixactID wrap-around management. <br />> Afaics, it is possible to spawn
multixactidsso quickly to have a<br />> wrap-around and to start overwriting the data stored in the offset<br />>
slru(but analogous considerations apply to the member slru as<br />> well).<br /><br />I looked into this when the
multixactcode was written. There is a<br />theoretical risk but I think it's entirely theoretical. MXIDs are<br
/>unlikelyto be consumed faster than XIDs over the long term, and also<br />can be recycled sooner. So you'd run up
againstXID wraparound (which<br />we do defend against) first.<br /><br /> regards, tom lane<br /></blockquote><br
/><p>Chiacchiera con i tuoi amici in tempo reale! <br />
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com 

pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: update/insert, delete/insert efficiency WRT vacuum and
Next
From: "Zeugswetter Andreas DCP SD"
Date:
Subject: Re: update/insert, delete/insert efficiency WRT vacuum and