On 20.02.2018 14:26, Simon Riggs wrote:
As far as I understand, it is necessary to traverse the whole page to locate root tuple, isn't it? If so, then I expect it to be too expensive operation. Scanning the whole page on tuple update seems to be not an acceptable solution.Try locking the root tid rather than the TID, that is at least unique per page for a chain of tuples, just harder to locate.
-- Konstantin Knizhnik Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
