Re: idle in transaction query makes server unresponsive

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: idle in transaction query makes server unresponsive
Дата
Msg-id CAKt_Zft42oRApV=WbeVh8+0REde8Aah9VNfnu2apPg6HsLEz+A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: idle in transaction query makes server unresponsive  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Ответы Re: idle in transaction query makes server unresponsive  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general
Дерево обсуждения
If it is truly idle in a transaction, maybe it has locks that are holding up other transactions?

Locks are usually held until commit time, except advisory locks iirc but those have to be explicitly checked, so if you don't know if you are using them you probably aren't.

Long-running transactions are generally a problem particularly when you  have idle blocks of space between them.  Try shortening your transactions and see if that helps.

Best Wishes,
Chris Travers

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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: idle in transaction query makes server unresponsive
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: idle in transaction query makes server unresponsive