From: | Greg Stark <gsstark(at)mit(dot)edu> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | Herouth Maoz <herouth(at)unicell(dot)co(dot)il>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Questions about connection clean-up and "invalid page header" |
Date: | 2010-01-25 11:26:17 |
Message-ID: | 407d949e1001250326j47c812d4v932ba9a85bb78dcb@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On Mon, Jan 25, 2010 at 8:15 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 2010-01-25 11:37:31 | Re: Questions about connection clean-up and "invalid page header" |
Previous Message | Magnus Hagander | 2010-01-25 11:11:40 | Re: Help: Postgresql on Microsoft cluster (MSCS) |
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 2010-01-25 11:37:31 | Re: Questions about connection clean-up and "invalid page header" |
Previous Message | Craig Ringer | 2010-01-25 10:42:06 | Re: pg_listener entries deleted under heavy NOTIFY load only on Windows |