On Mon, Jan 25, 2010 at 8:15 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>> Is there a parameter to set in the configuration or some other means to
>> shorten the time before an abandoned backend's query is cancelled?
>
> You can shorten the tcp_keepalive settings so that dead connections
> get detected faster.
>
This won't help. The TCP connection is already being closed (or I
think only half-closed). The problem is that in the Unix socket API
you don't find out about that unless you check or try to read or write
to it.
The tcp_keepalive setting would only come into play if the remote
machine crashed or was disconnected from the network.
--
greg