Re: vacuum vs heap_update_tuple() and multixactids - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: vacuum vs heap_update_tuple() and multixactids
Date
Msg-id 20171219183512.5clw3fxztholw4vq@alvherre.pgsql
Whole thread Raw
In response to vacuum vs heap_update_tuple() and multixactids  (Andres Freund <andres@anarazel.de>)
Responses Re: vacuum vs heap_update_tuple() and multixactids  (Andres Freund <andres@anarazel.de>)
Re: vacuum vs heap_update_tuple() and multixactids  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Andres Freund wrote:

> I think the bugfix is going to have to essentially be something similar
> to FreezeMultiXactId(). I.e. when reusing an old tuple's xmax for a new
> tuple version, we need to prune dead multixact members. I think we can
> do so unconditionally and rely on multixact id caching layer to avoid
> unnecesarily creating multis when all members are the same.

Actually, isn't the cache subject to the very same problem?  If you use
a value from the cache, it could very well be below whatever the cutoff
multi was chosen in the other process ...

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: vacuum vs heap_update_tuple() and multixactids
Next
From: Andres Freund
Date:
Subject: Re: vacuum vs heap_update_tuple() and multixactids