Hello Alexander, 05.02.2024 02:51, Alexander Korotkov wrote:
Usage of heap_inplace_update() seems appropriate for me here. It avoids trouble with both TOAST and row-level locks. Alexander, could you please recheck this fixes the problem.
I've re-tested the last problematic scenario and can confirm that the fix works for it (though it still doesn't prevent the autovacuum issue (with 4b885d01 reverted)), but using heap_inplace_update() was considered risky in a recent discussion: https://www.postgresql.org/message-id/1596629.1698435146%40sss.pgh.pa.us So maybe it's worth to postpone such a fix till that discussion is finished or to look for another approach... Best regards, Alexander