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 20090731.231144.02445514.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Clients disconnect but query still runs  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
> > 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.

Can't we expect such a transient error to be fixed by underlying
TCP/IP stack?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

pgsql-general by date:

Previous
From: Jennifer Trey
Date:
Subject: Re: Can I have a look at your TuningWizard generated config file?
Next
From: Alvaro Herrera
Date:
Subject: Re: Can I have a look at your TuningWizard generated config file?