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
Hi ,
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' tab I
can see UPDATE stateme
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
I'm having a bear of a time with an application where one thread seems
to be keeping a lock on a table after it's supposed to release it.
select count(*) from pg_locks gives:
6816
Is there any way to get the list of locks by transation id or some
other datum to indicate which was first, or to fig
