Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL server does not notice that clients have disappeared - Mailing list pgsql-general

From Al Eridani
Subject Re: PostgreSQL server does not notice that clients have disappeared
Date
Msg-id CAN-56bhDqWQUQ6KdrGNjxOshNWFUpDkB9NCq4jqq7UBoxiSq3w@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL server does not notice that clients have disappeared  (Maciek Sakrejda <maciek@heroku.com>)
List pgsql-general
Tree view
Thank you for the confirmation!

On Fri, Jan 23, 2015 at 1:24 PM, Maciek Sakrejda <maciek@heroku.com> wrote:
On Fri, Jan 23, 2015 at 12:08 PM, Al Eridani <al.eridani@gmail.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.

pgsql-general by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: PostgreSQL server does not notice that clients have disappeared
Next
From: Adrian Klaver
Date:
Subject: Re: Postgres seems to use indexes in the wrong order