Re: Peter Eisentraut 2016-08-08 <1e904e8c-0abc-71ac-6d19-bb7255cec...@debian.org> > On 8/8/16 10:05 AM, Christoph Berg wrote: > > I'm still curious why PG doesn't just cancel the query by itself on > > SIGPIPE. Is there any value in running queries to completion when the > > user has already left? Are these queries even committed? > > I haven't tested this in detail for local socket connections, but for > TCP/IP, the backend carries on if the client disappears. The > server-side TCP keepalive settings are there to control this to some extent.
I mean... why? If PG receives SIGPIPE in that case (I haven't tested it, but I believe it does), why carry on? (Of course TCP keepalive is still useful for the cases where the remote OS didn't send a RST, but when it does, why not use it?) Christoph
signature.asc
Description: PGP signature
