Robert Haas <robertmh...@gmail.com> writes: > I just want to mention that I have heard of "stuck spinlock" happening > in production just because the server was busy. And I think that's not > intended. The timeout is supposed to be high enough that you only hit > it if there's a bug in the code. At least AIUI. But it isn't.
Well, certainly that's not supposed to happen, but anecdotal reports like this provide little basis for discussing what we ought to do about it. It seems likely that raising the timeout would do nothing except allow the stuck state to persist even longer before failing. (Keep in mind that the existing timeout of ~2 min is already several geological epochs to a computer, so arguing that spinning another couple minutes would have resulted in success seems more like wishful thinking than reality.) regards, tom lane