Postgres Pro
Downloads
Home   >   mailing lists

8.1.2 locking issues - Mailing list pgsql-general

From Ed L.
Subject 8.1.2 locking issues
Date
Msg-id 200611081423.42691.pgsql@bluepolka.net
Whole thread Raw
Responses Re: 8.1.2 locking issues  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
We are having locking issues in 8.1.2 on HP 11.23 ia64.  I'm
trying to better understand how to conclusively identify who is
waiting on who and why.

We have a series of "select for updates" on our 'sessions' table.
One of those queries is stuck waiting for a "transactionid"
locktype ShareLock.  How can I tell what it's actually waiting
for?

TIA.
Ed

pgsql-general by date:

Previous
From: "Talha Khan"
Date:
Subject: Re: 8.1.2 postmaster died
Next
From: Jeff Davis
Date:
Subject: Re: [solved] WAL ends before end time of backup dump