Re: Clients disconnect but query still runs

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Clients disconnect but query still runs
Дата
Msg-id 20090730.164133.66734583.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: Clients disconnect but query still runs  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Clients disconnect but query still runs
Список pgsql-general
> Well SIGPIPE is no help since it would only fire if we tried to write
> to the socket anyways.

Right. For this purpose, pgpool sends param packet to client
periodically while waiting for a reply from backend to detect if the
connection to the client is broken. If it's broken, pgool sends cancel
packet to backend not to waste backend machine's CPU cycle.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_stat_activity undocumented?
Следующее
От: Dotan Barak
Дата:
Сообщение: PostgreSQL server listen on other port than 5432