Re: Whats is lock type transactionid?

Поиск
Список
Период
Сортировка
От AI Rumman
Тема Re: Whats is lock type transactionid?
Дата
Msg-id CAGoODpdqSuY==HVQyNNT4qFZuBZHN7jTRviWNg5PztEZ1L_GOw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Whats is lock type transactionid?  (Douglas J Hunley <doug.hunley@gmail.com>)
Список pgsql-general
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.hunley@gmail.com> wrote:

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 по дате отправления:

Предыдущее
От: Lists
Дата:
Сообщение: Detect streaming replication failure
Следующее
От: Prabhjot Sheena
Дата:
Сообщение: Re: Checkpoint_segments optimal value