[SQL] commit not completing - how to investigate?

Поиск
Список
Период
Сортировка
От Tim Dudgeon
Тема [SQL] commit not completing - how to investigate?
Дата
Msg-id 5e59f5e0-7168-fb80-d038-7fe9adad4aa9@gmail.com
обсуждение исходный текст
Ответы Re: [SQL] commit not completing - how to investigate?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Дерево обсуждения 
I have a situation where the pg_stat_activity view shows that can have 
some processes that are idle and not completing. In some cases the 
statement being executed is COMMIT.

How can I investigate WHY these processes are not completing. Presumably 
they are waiting on something, but I'm not sure how to work out what 
this is.

Thanks
Tim

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Maddali, Srinivas"
Дата:
Сообщение: [SQL] Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database inread write
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] commit not completing - how to investigate?