On Thu, Jul 17, 2014 at 3:34 PM, AI Rumman rumman...@gmail.com wrote:
Hi,
I have been facing lock contention in my Postgresql 9.1 DB.
And when I am querying in the pg_locks table I found a lock type with
transactionid.
Could someone please tell me what it means?
Thanks.
from
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.
I got a log like follows:
blocker_target
On Thu, Jul 17, 2014 at 12:54 PM, AI Rumman rumman...@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
Yes. But as we are using bind variables, we are not able to get the ID of
the tuple.
On Thu, Jul 17, 2014 at 2:08 PM, Douglas J Hunley doug.hun...@gmail.com
wrote:
On Thu, Jul 17, 2014 at 12:54 PM, AI Rumman rumman...@gmail.com wrote:
I am experiencing lock contention on one single UPDATE