Re: PostgreSQL server does not notice that clients have disappeared

From: Al Eridani <al(dot)eridani(at)gmail(dot)com>
To: "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:43:07
Message-ID: CAN-56bhDqWQUQ6KdrGNjxOshNWFUpDkB9NCq4jqq7UBoxiSq3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you for the confirmation!

On Fri, Jan 23, 2015 at 1:24 PM, Maciek Sakrejda <maciek(at)heroku(dot)com> wrote:

> 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

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-01-24 00:25:57 Re: Postgres seems to use indexes in the wrong order
Previous Message Maciek Sakrejda 2015-01-23 23:24:36 Re: PostgreSQL server does not notice that clients have disappeared