On Thu, Jul 17, 2014 at 12:54 PM, AI Rumman <rummandba(at)gmail(dot)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(dot)hunley(at)gmail(dot)com)