Hello! On Wed, Apr 15, 2026 at 4:50 PM Antonin Houska <[email protected]> wrote: > The approach proposed by Mihail [1] seems the least problematic to me, and > something like that occurred to me when I thought about the problem the first > time. However, when we wake up the other processes in order to run the > deadlock detection, they should do that immediately. I've got no good idea > about implementation at the moment, since latch can be set for unrelated > reasons. (Besides that, I have some more questions about this patch, which I > can post separately.)
It is already possible to "deadlock" ANOTHER backend while running the deadlock check [0]. Supported in current infra, just not used at the moment (my POC used that also). [0]: https://github.com/postgres/postgres/blob/master/src/backend/storage/lmgr/proc.c#L1870-L1873
