Re: Row locking during UPDATE - Mailing list pgsql-admin

From Tom Lane
Subject Re: Row locking during UPDATE
Date
Msg-id 28514.1062689108@sss.pgh.pa.us
Whole thread Raw
In response to Re: Row locking during UPDATE  ("David F. Skoll" <dfs@roaringpenguin.com>)
List pgsql-admin
"David F. Skoll" <dfs@roaringpenguin.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

pgsql-admin by date:

Previous
From: "Marc Mitchell"
Date:
Subject: Recovery assistence....
Next
From: Sam Barnett-Cormack
Date:
Subject: Re: Row locking during UPDATE