Re: Database locks - Mailing list pgsql-general

From Tom Lane
Subject Re: Database locks
Date
Msg-id 19217.1108746788@sss.pgh.pa.us
Whole thread Raw
In response to Database locks  (Alex Turner <armtuk@gmail.com>)
List pgsql-general
Alex Turner <armtuk@gmail.com> 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 be
blocking the most people.

            regards, tom lane

pgsql-general by date:

Previous
From: John Sidney-Woollett
Date:
Subject: Re: PostgreSQL Replication
Next
From: Clemens Wehrmann
Date:
Subject: Debugging a postgresql server crash.