On Mon, Aug 4, 2025 at 5:54 PM Thomas Munro <thomas.mu...@gmail.com> wrote: > I doubt it's very easy to reproduce with simple queries, but I assume > if you had a SQL function that acquires a central LWLock and you ran > concurrent queries SELECT COUNT(*) FROM t WHERE locking_function(x)
Hmm, that's a bad example as it has the wrong lock scope. Probably would need a dedicated test to demonstrate with low level functions. What I was trying to convey is that it's not a problem that can be hit in practice without great effort as far as I know, but it does break an intended pgaio architectural principle as I understand it. Also I accidentally sent that to -bugs by fat fingering an autocompletion. Moving to -hackers.
