On Thu, Jul 30, 2009 at 8:41 AM, Tatsuo Ishii<ishii(at)postgresql(dot)org> wrote:
>> 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.
The downside to this is that it will cause spurious failures for
transient network failures even if the network comes back before it's
actually needed.
--
greg
http://mit.edu/~gsstark/resume.pdf