Re: zombie connections

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: zombie connections
Дата
Msg-id CAFj8pRD01240x1gKnVWJzoc8pd6=5Nna_ZNkoajL54MqHmUwGg@mail.gmail.com
обсуждение исходный текст
Ответ на zombie connections  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: zombie connections
Список pgsql-hackers


pá 3. 4. 2020 v 14:30 odesílatel Robert Haas <robertmhaas@gmail.com> napsal:
Hi,

Suppose that the server is executing a lengthy query, and the client
breaks the connection. The operating system will be aware that the
connection is no more, but PostgreSQL doesn't notice, because it's not
try to read from or write to the socket. It's not paying attention to
the socket at all. In theory, the query could be one that runs for a
million years and continue to chew up CPU and I/O, or at the very
least a connection slot, essentially forever. That's sad.

I don't have a terribly specific idea about how to improve this, but
is there some way that we could, at least periodically, check the
socket to see whether it's dead? Noticing the demise of the client
after a configurable interval (maybe 60s by default?) would be
infinitely better than never.

+ 1

Pavel


--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: zombie connections
Следующее
От: Prabhat Sahu
Дата:
Сообщение: Re: [Proposal] Global temporary tables