Re: [GENERAL] database locks

2007-03-15 Thread Albe Laurenz
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

Re: [GENERAL] Database locks

2005-02-18 Thread Tom Lane
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