On Mon, Jan 25, 2010 at 8:15 AM, Scott Marlowe <scott.marl...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
