Home > mailing lists

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

From	Al Eridani
Subject	PostgreSQL server does not notice that clients have disappeared
Date	January 23, 2015 23:08:21
Msg-id	CAN-56bgTt9LiQZLAUR3xL73rFNPnifpbEq4oj1LL9N+uEbiwzg@mail.gmail.com Whole thread Raw
Responses	Re: PostgreSQL server does not notice that clients have disappeared
List	pgsql-general

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 an attempt to output to the

client fails. It does not spend cycles looking aside to see if the

connection has dropped when it is doing something that doesn't involve

output to the client."

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

From: "ktm@rice.edu"
Date: 23 January 2015, 23:07:12
Subject: Re: [SQL] commit inside a function failing

From: Tim Smith
Date: 23 January 2015, 23:20:52
Subject: Re: In need of some JSONB examples ?