Tomasz Rakowski wrote:
> I'm facing frustrating problem with locking in
> postgres server. I have application which do update
> one table few thousands time each minute. From time to
> time call to database is locked and is waiting for something
> (In pgAdmin3 in 'Server Status' window in 'Lock' t
Alex Turner <[EMAIL PROTECTED]> writes:
> Is there any way to get the list of locks by transation id or some
> other datum to indicate which was first, or to figure out which is the
> lock that is holding everything else back?
Perhaps get some stats on the rows with granted=f to see what seems to