"David F. Skoll" <dfs(at)roaringpenguin(dot)com> writes:
>> Which process does have the row lock, and why isn't it completing its
>> transaction?
> I don't know the details of PostgreSQL's implementation, but it seems
> that when lots of processes are waiting to update the same row, it
> gets incredibly slow.
Hmm. That might represent a fixable bug. How many is "lots"? Can you
give a self-contained test case?
regards, tom lane