On Fri, Jul 19, 2019 at 10:28 AM Robert Haas <robertmh...@gmail.com> wrote: > In scenario #2, the undo work is going to have to be retried in the > background, and perforce that means reacquiring locks that have been > released, and so there is a chance of long lock waits and/or deadlock > that cannot really be avoided.
I haven't studied the UNDO or zheap stuff in any detail, but I am concerned about rollbacks that deadlock. I'd feel a lot better about it if forward progress was guaranteed, somehow. That seems to imply that locks are retained, which is probably massively inconvenient to ensure. Not least because it probably requires cooperation from underlying access methods. -- Peter Geoghegan
