Postgres Pro
Downloads
Home   >   mailing lists

Re: Whats is lock type transactionid? - Mailing list pgsql-general

From Douglas J Hunley
Subject Re: Whats is lock type transactionid?
Date
Msg-id CALxYTP7-Oz2P3_VhX4O19zrqRz2c6pWDi6dxGNThfW-A10oD3g@mail.gmail.com
Whole thread Raw
In response to Re: Whats is lock type transactionid?  (AI Rumman <rummandba@gmail.com>)
Responses Re: Whats is lock type transactionid?  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Tree view

On Thu, Jul 17, 2014 at 12:54 PM, AI Rumman <rummandba@gmail.com> wrote:
I am experiencing lock contention on one single UPDATE statement at a certain time in whole day. This is a small table to UPDATE.
My suspect is we are facing it for one specific ID.
Could you please let me know how can I identify the tuple.

Have you tried the lock monitoring queries on http://wiki.postgresql.org/wiki/Lock_Monitoring yet by chance?


--
Douglas J Hunley (doug.hunley@gmail.com)

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: Re: Whats is lock type transactionid?
Next
From: Lists
Date:
Subject: Detect streaming replication failure