| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 8.1.2 locking issues |
| Date: | 2006-11-08 22:41:20 |
| Message-ID: | 20061108224120.GO14845@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ed L. wrote:
>
> 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?
There should be tuple locks on pg_locks for the transaction that holds
the transactionid that your transaction is waiting on.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-11-08 22:45:52 | Re: [solved] WAL ends before end time of backup dump |
| Previous Message | Jeff Davis | 2006-11-08 22:22:16 | Re: [solved] WAL ends before end time of backup dump |