PostgreSQL server does not notice that clients have disappeared

Поиск
Список
Период
Сортировка
От Al Eridani
Тема PostgreSQL server does not notice that clients have disappeared
Дата
Msg-id CAN-56bgTt9LiQZLAUR3xL73rFNPnifpbEq4oj1LL9N+uEbiwzg@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL server does not notice that clients have disappeared  (Maciek Sakrejda <maciek@heroku.com>)
Список pgsql-general
Дерево обсуждения
More than five years ago Tom Lane wrote

"It's not easy to tell whether a client has disconnected (particularly if
the network stack is unhelpful, which is depressingly often true).
Postgres will cancel a query if it gets told that the connection's been
dropped, but it will only discover this when an attempt to output to the
client fails. It does not spend cycles looking aside to see if the
connection has dropped when it is doing something that doesn't involve
output to the client."

Is this still true on the 9.x versions? Thanks!

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

Предыдущее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: [SQL] commit inside a function failing
Следующее
От: Tim Smith
Дата:
Сообщение: Re: In need of some JSONB examples ?