Hello, I have two concurrent transactions, both heavy R/W type things. I now see that one is backed up behind in the other, and pg_locks shows me this: sep=# select locktype, transactionid, transaction from pg_locks where not granted; locktype | transactionid | transaction ---------------+---------------+------------- transactionid | 3391481 | 3391528 (1 row) The TFM tells me (in the description of pg_locks): "Every transaction holds an exclusive lock on its transaction ID for its entire duration. If one transaction finds it necessary to wait specifically for another transaction, it does so by attempting to acquire share lock on the other transaction ID. That will succeed only when the other transaction terminates and releases its locks." So what could make my transaction decide to wait for that other tx? I've checked to see that all updates to rows shared by the two transactions are done late in the process, but this lock happens almost immediately after the second tx starts... Comments? jan -- -------------------------------------------------------------- Jan de Visser jdevisser@xxxxxxxxxxxxxxxxxx Baruk Khazad! Khazad ai-menu! -------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
