Re: Faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination
Alvaro Herrera <alvherre@alvh.no-ip.org>
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: Mahendra Singh Thalor <mahi6run@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-02-04T17:36:37Z
Lists: pgsql-hackers
On 2021-Feb-05, Julien Rouhaud wrote: > Thanks, that's way better, copied in v3. I'm still a bit worried about that > description though, as that flag isn't consistently set for the FOR UPDATE > case. Well, to be more precise it's maybe consistently set when the hint bits > are computed, but in some cases the flag is later cleared, so you won't > reliably find it in the tuple. Hmm, that sounds bogus. I think the resetting of the other bits should be undone afterwards, but I'm not sure that we correctly set KEYS_UPDATED again after the TOAST business. (What stuff does, from memory, is to make the tuple look as if it is fully updated, which is necessary during the TOAST handling; if the bits are not correctly set transiently, that's okay. But it needs reinstated again later, once the TOAST stuff is finished). -- Álvaro Herrera 39°49'30"S 73°17'W "El número de instalaciones de UNIX se ha elevado a 10, y se espera que este número aumente" (UPM, 1972)
Commits
-
Reinstate HEAP_XMAX_LOCK_ONLY|HEAP_KEYS_UPDATED as allowed
- bf518fefacc7 10.17 landed
- 8deb6b38dc4c 14.0 landed
- 28f4b61083b2 13.3 landed
- 2796ae2ad253 12.7 landed
- 2583917075ae 11.12 landed
- 0ccebe779dc0 9.6.22 landed