Re: Clients disconnect but query still runs - Mailing list pgsql-general

From Tatsuo Ishii
Subject Re: Clients disconnect but query still runs
Date
Msg-id 20090730.164133.66734583.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Clients disconnect but query still runs  (Greg Stark <gsstark@mit.edu>)
Responses Re: Clients disconnect but query still runs
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pg_stat_activity undocumented?
Next
From: Dotan Barak
Date:
Subject: PostgreSQL server listen on other port than 5432