Re: PostgreSQL server does not notice that clients have disappeared

From: Maciek Sakrejda <maciek(at)heroku(dot)com>
To: Al Eridani <al(dot)eridani(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL server does not notice that clients have disappeared
Date: 2015-01-23 23:24:36
Message-ID: CAKwe89CrCoN8OW6kbo7=E5A-cPfje+vxbd7ctRVLyVWrYFYfDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jan 23, 2015 at 12:08 PM, Al Eridani <al(dot)eridani(at)gmail(dot)com> wrote:

> Is this still true on the 9.x versions? Thanks!
>

It is, unfortunately. If your client kicks off a 12h query and immediately
closes the TCP connection, Postgres won't notice until the query has
completed.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Al Eridani 2015-01-23 23:43:07 Re: PostgreSQL server does not notice that clients have disappeared
Previous Message Adrian Klaver 2015-01-23 22:54:47 Re: CLOG read problem after pg_basebackup