Jeff <threshar@torgo.978.org> writes:
> Eventually PG would have found out the socket was dead.
We do enable TCP keepalive on the client socket, so eventually the
kernel will time out and notify us of a lost connection. Unfortunately
the timeouts involved are long --- IIRC the relevant RFCs specify at
least an hour.
regards, tom lane