Re: Clients disconnect but query still runs

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: gsstark(at)mit(dot)edu
Cc: jasen(at)xnet(dot)co(dot)nz, pgsql-general(at)postgresql(dot)org
Subject: Re: Clients disconnect but query still runs
Date: 2009-07-31 14:11:44
Message-ID: 20090731.231144.02445514.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-07-31 14:17:21 Re: Can I have a look at your TuningWizard generated config file?
Previous Message Jennifer Trey 2009-07-31 14:02:54 Re: Can I have a look at your TuningWizard generated config file?