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-30 07:41:33
Message-ID: 20090730.164133.66734583.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dotan Barak 2009-07-30 08:01:25 PostgreSQL server listen on other port than 5432
Previous Message Magnus Hagander 2009-07-30 07:24:43 Re: pg_stat_activity undocumented?