Thank you for the confirmation!
On Fri, Jan 23, 2015 at 1:24 PM, Maciek Sakrejda wrote:
> On Fri, Jan 23, 2015 at 12:08 PM, Al Eridani 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 c
On Fri, Jan 23, 2015 at 12:08 PM, Al Eridani 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.
More than five years ago Tom Lane wrote
"It's not easy to tell whether a client has disconnected (particularly if
the network stack is unhelpful, which is depressingly often true).
Postgres will cancel a query if it gets told that the connection's been
dropped, but it will only discover this when
