Re: Deadlock detection

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: Deadlock detection
Дата
Msg-id 4976F543.1050704@opencloud.com
обсуждение исходный текст
Ответ на Deadlock detection  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-jdbc
Simon Riggs wrote:

> I'm thinking of some simple bookkeeping, so that before any session
> issues a blockable call it takes note that it is doing so in a shared
> array, and clears that state again once released. A single watcher
> thread can then regularly scan the state array and see if a session is
> marked as waiting on both send and receive. Side threads are already
> used for login timeout handling, so that mechanism is already in use.
> Some loss of performance would be acceptable.

I don't see how this can work. The whole point is that if we're blocked
on send, we're *not* blocked on receive by definition.

-O

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Deadlock detection
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: Deadlock detection