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

From Greg Stark
Subject Re: Clients disconnect but query still runs
Date
Msg-id 407d949e0907300154n169c5713p7722bf7bf753e08f@mail.gmail.com
Whole thread Raw
In response to Re: Clients disconnect but query still runs  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: Clients disconnect but query still runs
List pgsql-general
On Thu, Jul 30, 2009 at 8:41 AM, Tatsuo Ishii<ishii@postgresql.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

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: pg_stat_activity undocumented?
Next
From: Greg Stark
Date:
Subject: Re: Clients disconnect but query still runs